Wednesday, 31 December 2014

Exploring Oracle Data Guard - Part 3

Now It's time to get our hands dirty in the process of creating a physical standby database.

6) Copy the  orapwfile of the primary database to the standby database :

scp orapwTESTDG oracle@oracle10gr2standbybis:$ORACLE_HOME/dbs
     


7) Add the following alias to the tnsnames.ora file of the primary database :

 TESTDGS =
         (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
            (CONNECT_DATA =
               (SERVER = DEDICATED)
               (SERVICE_NAME = TESTDGS)
              )
         )





Nb: The service name TESTDGS is going to be managed by the listener process of standby database
 
To be continued.....

No comments:

Post a Comment