Member Avatar for PerfTuning
PerfTuning 0 Newbie Poster

Hi Everyone,

Just joined the community and wanted to share a quick "how-to" for anyone experiencing errors when setting up Oracle GoldenGate's archive settings.

The default configuration of an Oracle database created with DBCA is to allow archiving to follow default settings. This in essence sets the log archive location to be the Fast Recovery area or the location set by the db_recovery_file_dest initialization parameter.

Well, GoldenGate does not understand the Oracle defaults and you will get an error telling you that the archive location is not set up properly. In order to avoid this simply set the following Oracle initialization parameter:

LOG_ARCHIVE_DEST_10 = ‘LOCATION=USE_DB_RECOVERY_FILE_DEST’

GoldenGate will be happy with this archive settings and you will no longer see the GoldenGate errors.

  • 1 Contributor
  • 0 Replies
  • 57 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.