|
 |
|
< Data GuardDonald K. Burleson
Oracle Data GuardChapter 3 - Implementing Standby
Databases
For a description of the DBA wait event views,
see the "free
11g poster" by Quest Software.
Starting the Standby Database
STARTUP MOUNT
Mount the Oracle instance
using the following
statement:
ALTER
DATABASE MOUNT STANDBY DATABASE;
At this point, the Oracle instance
is up and
running and ready to receive archived redo logs from the primary
database even though, the logs will not be applied until the
database is put in managed recovery mode.
Verify the Physical Standby
Database
The complete setup can be verified by switching
a log file on the primary database and checking the file on the
Oracle instance
in the STANDBY_ARCHIVE_DEST directory. Moreover,
the Oracle Net setup for standby locations can be verified from the
v$archive_dest view on the primary database.
Assume that on the standby site, the listener
is not running. Querying the v$archive_dest view will show this
error.
Select
Status, Error
|
