Whats errors in my steps I did to adjust data guard between (2) databases(Primary & standby) databas
edited Jan 28, 2012 7:23PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
I have 2 databases :
Primary Database name = MNDB
Standby Database = DRDB
OS platform : IBM AIX 5.3
I did the following setps to adjust dataguard between 2 databases (MNDB & DRDB)
but I am not succeed pls check these steps and help me to correct the wrong things.
---------------------------- MNDB ----------------------------
----------------------Primary Database ------------------------
alter database create standby controlfile as '/u01/oracle/control01.ctl';
cp initMNDB.ora initDRDB.ora
cp orapwMNDB.ora orapwDRDB.ora
=========================================
alter system set log_archive_config='dg_config=(MNDB,DRDB)' SCOPE=BOTH;
take db uniq name as MNDB & DRDB
show parameter db_unique_name
=======================
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable;
Primary Database name = MNDB
Standby Database = DRDB
OS platform : IBM AIX 5.3
I did the following setps to adjust dataguard between 2 databases (MNDB & DRDB)
but I am not succeed pls check these steps and help me to correct the wrong things.
---------------------------- MNDB ----------------------------
----------------------Primary Database ------------------------
alter database create standby controlfile as '/u01/oracle/control01.ctl';
cp initMNDB.ora initDRDB.ora
cp orapwMNDB.ora orapwDRDB.ora
=========================================
alter system set log_archive_config='dg_config=(MNDB,DRDB)' SCOPE=BOTH;
take db uniq name as MNDB & DRDB
show parameter db_unique_name
=======================
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable;
0