Otherwise, this command generates a message reminding you to change the DB_
NAME parameter in your initialization parameter file after shutting down the database.
Physical standby databases operate in read-only mode; logical standby databases are open for
writes and generate their own redo data. In the initialization file for the logical standby database,
specify destinations for the logical standby database??™s redo data (LOG_ARCHIVE_DEST_1) and
the incoming redo from the primary database (in this example, LOG_ARCHIVE_DEST_3 will be
used to avoid conflicts with the earlier LOG_ARCHIVE_DEST_2 setting). You do not want a
logical standby database to have the LOG_ARCHIVE_DEST_2 destination enabled and pointing
back to the primary database.
Shut down and start up the database and change these parameters:
shutdown;
startup mount;
Step 4: Start the Logical Standby Database
Open the logical standby database using its new initialization parameter file or SPFILE as follows:
alter database open resetlogs;
Because this is the first time the database is opened after being converted to a standby, the
database??™s global name is adjusted to match the new DB_NAME initialization parameter.
Step 5: Start the Redo Application Process
Within the logical standby database, you can now start the redo application process:
alter database start logical standby apply immediate;
To see the logs that have been received and applied to the logical standby database, query the
DBA_LOGSTDBY_LOG view.
Pages:
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737