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