Data Guard

Oracle Data GuardChapter 3 - Implementing Standby Databases

Modifying the Initialization Parameter File

UNDO_MANAGEMENT=AUTO
UNDO_TABLESPACE=undotbs

Up to nine standby databases can be added in the log_archive list. The keyword service in the log_archive_dest_2 parameter value list this indicates that the archive destination is an Oracle service, which is defined in the tnsnames.ora file on the primary site. log_archive_dest_n parameter has several options to control the behavior of the log transfer service. These options are explained later in this book.

On the standby site, the following parameters will have to be changed:

• control_file
   

• standby_archive_dest
   

• log_archiver_format
   

• fal_server
   

• fal_client

Moreover, setting the parameter log_archive_trace will be useful in troubleshooting. A brief description of log_archive_trace parameter is given below the example code. The following example shows the modification on the standby initialization file: