The filename conversions should be the same as in the primary
database??”you want to convert the filenames from the primary database to the standby database
format when the redo information is applied:
LOG_ARCHIVE_DEST_1=
'LOCATION=/arch/salesofc/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=salesofc'
LOG_ARCHIVE_DEST_2=
'SERVICE=headqtr
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
In the standby environment, the LOG_ARCHIVE_DEST_1 parameter points to its local archive
log destination, and LOG_ARCHIVE_DEST_2 points to the primary database??™s service name. If the
roles of the two databases are switched, the original primary database will be able to serve as the
standby database. While the standby database is running in standby mode, the LOG_ARCHIVE_
DEST_2 value will be ignored.
NOTE
Set the COMPATIBLE parameter to the same value for both the
primary and standby databases. To take advantage of the new features
in Oracle 11g, set the COMPATIBLE value to 11.0.0 or higher. Once
COMPATIBLE is set to 11.0.0, you cannot reset it to a lower value.
Chapter 13: Oracle Data Guard 483
Step 4: Copy the Database Files to the Standby Database Location
Copy the datafiles from Step 1, the controlfile from Step 2, and the standby initialization file from
Step 3 to the standby database location. Put the files in the proper directories (as defined by the
CONTROL_FILES, DB_FILE_NAME_CONVERT, and LOG_FILE_NAME_CONVERT parameters).
Pages:
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732