How to rollback standby database site to prior 'Active Data Guard'
edited Apr 18, 2012 10:15PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Dears,
I am trying Oracle Active Data Guard 11.2.0.3.
On Standby site I tried :
1. stop redo apply with : sql> RECOVER MANAGED STANDBY DATABASE CANCEL;
2. open db read only : sql > ALTER DATABASE OPEN READ ONLY;
3. start redo apply with : sql> RECOVER MANAGED STANDBY DATABASE DISCONNECT USING CURRENT LOGFILE;
On Primary, I tried create table with 'create table TBL3_DBA_OBJECTS as (select * from dba_objects union all select * from dba_objects), commit;
but on Standby site after wait 30 minutes, I didn't see table 'TBL3_DBA_OBJECTS',
Then I decided to stop data guard on standby site and primary site, on standby I tried with : recover managed standby database cancel; and shutdown immediate;
I am trying Oracle Active Data Guard 11.2.0.3.
On Standby site I tried :
1. stop redo apply with : sql> RECOVER MANAGED STANDBY DATABASE CANCEL;
2. open db read only : sql > ALTER DATABASE OPEN READ ONLY;
3. start redo apply with : sql> RECOVER MANAGED STANDBY DATABASE DISCONNECT USING CURRENT LOGFILE;
On Primary, I tried create table with 'create table TBL3_DBA_OBJECTS as (select * from dba_objects union all select * from dba_objects), commit;
but on Standby site after wait 30 minutes, I didn't see table 'TBL3_DBA_OBJECTS',
Then I decided to stop data guard on standby site and primary site, on standby I tried with : recover managed standby database cancel; and shutdown immediate;
0