Data Guard

Oracle Data GuardChapter 3 - Implementing Standby Databases

Oracle Net Configuration

The host, port, and sid parameters of the tnsnames file for the primary database on the standby site should match the host, port, and sid parameters of the listener file for the primary database on the primary site.  Similarly, the tnsnames setting for the standby site on the primary database should match the listener setting for the Oracle instance on the standby site.

Starting the Standby Database

After configuring the initialization parameters, Oracle Net, and copying the backup files from the primary site to the standby site, everything is ready for the starting of the standby database. The Oracle instance will be mounted and put in managed recovery mode using the following statements in the order presented: issue the startup nomount and mount the standby database.  Before issuing these commands, set the oracle_sid environment variable to appropriate value.

$ export ORACLE_SID=appsdb
$ sqlplus /nolog

sql> connect sys/<passwd> as sysdba

If the initialization file is in $ORACLE_HOME/dbs directory, it does not have to pass as an argument to the startup command. If the initialization file from some other location is to be used, pass it as PFILE=’<file location>’ argument.