Flashback Oracle RAC Database with Dataguard

 

Flashback Oracle RAC Database with Dataguard

 

##########   Creating  Restore Point  ############

1)  Stop Redo Transport and Redo Apply 

A)  When we Dont have Broker Configuration  

alter system set log_archive_dest_state_n='defer'  sid='*' ;   ( On primary ) 

alter database recover managed standby database cancel  ;  

 ( On Standby ) 

B)  When we have Broker Configuration  

edit database Chicago  set state='TRANSPORT-OFF'; 

EDIT database Boston  set state='apply-off' ; 

2) Create Restore  Point (in Standby First   ) 

create  restore point GRP_DG GUARANTEE FLASHBACK DATABASE ;  

 ( On Standby ) 

create  restore point GRP_PR  GUARANTEE FLASHBACK DATABASE ;   ( On Primary ) 

3) Enable Log Transport and Apply 

A) When we Dont have Broker Configuration  

alter system set log_archive_dest_state_n='enable'  sid='*' ;   ( On primary ) 

alter database recover managed standby databsae  using current logfile  disconnect ;  ( on  Standby ) 

B)  When we chave Broker Configuration 

edit database Chicago  set state='TRANSPORT-On'; 

EDIT database Boston  set state='apply-on' ; 

##########  Flashback Database   ############

1)  Stop Redo Transport and Redo Apply 

A)  When we Dont have Broker Configuration  

alter system set log_archive_dest_state_n='defer'  sid='*'  ;   ( On primary ) 

alter database recover managed standby database cancel  ;   

( On Standby ) 

B)  When we chave Broker Configuration  

edit database Chicago  set state='TRANSPORT-OFF'; 

EDIT database Boston  set state='apply-off' ; 

2 a) Flashbackup  Primary Database to restore Point 

srvctl stop database -d DB_NAME 

srvctl start instance -d DB_NAME -i instance_name -o mount 

flashback database to restore point GRP_PR ; 

alter database open resetlogs ; 

srvctl stop instance -d DB_NAME -i instance_name  

srvctl start database -d DB_NAME 

2 b) Flashbackup  Satndby Database to restore Point 

srvctl stop database -db  DB_NAME -stopoption immediate 

srvctl start instance -d DB_NAME -i instance_name -o mount 

flashback database to restore point GRP_DG ; 

srvctl stop instance -db DB_NAME -i instance_name  

srvctl start database -db DB_NAME -startoption  mount 

3) Enable Log Transport and Apply 

A) When we Dont have Broker Configuration  

alter system set log_archive_dest_state_n='enable'  SID='*';   ( On primary ) 

alter database recover managed standby databsae  using current logfile  disconnect ;  ( on  Standby ) 

B)  When we chave Broker Configuration 

edit database Chicago  set state='TRANSPORT-On'; 

EDIT database Boston  set state='apply-on' ; 

4)  Restart standby database on  Database pass through  resetlogs  and there is no lag 

########## Drop Restore Point   ############

1)  Stop Redo Transport and Redo Apply 

A)  When we Dont have Broker Configuration  

alter system set log_archive_dest_state_n='defer'  SID='*';  

 ( On primary ) 

alter database recover managed standby database cancel  ;   

( On Standby ) 

B)  When we chave Broker Configuration  

edit database Chicago  set state='TRANSPORT-OFF'; 

EDIT database Boston  set state='apply-off' ; 

2) Drop Restore  Point  

drop  restore point GRP_PR  ;   ( On Primary ) 

dROP  restore point GRP_dg   ;   ( On Standby ) 

3) Enable Log Transport and Apply 

A) When we Dont have Broker Configuration  

alter system set log_archive_dest_state_n='enable'  SID='*';   ( On primary ) 

alter database recover managed standby databsae  using current logfile  disconnect ;  ( on  Standby ) 

B)  When we chave Broker Configuration 

edit database Chicago  set state='TRANSPORT-On'; 

EDIT database Boston  set state='apply-on' ; 

########## Reference   ############

Metalink Doc   2338328.1