Guarantee Restore Point Primary-Standby Environment
Guarantee Restore Point Primary-Standby Environment: When we have a Data Guard environment (Primary RAC and Standby Standalone Databases) and we want to make use of restore points. We need to follow below steps. Always create a restore point on the standby database first then in Primary. The main reason for this is because the SCN of the standby must be less than the SCN of the primary in case you need to flashback your database. If we didn’t follow the step 1 then we need to rebuild the standby. 1.) Stop Managed Recovery on the Standby Database using SQL*PLUS or Data Guard Broker. $ dgmgrl sys/<Password>@<PRIM/STDBY> DGMGRL> show database ' STDBY '; edit database 'STDBY' set state = 'APPLY-OFF'; show database ' STDBY '; OR STDBY.SYS.SQL> select inst_id, process, status, thread#, sequence#, block#, blocks from gv$managed_standby order by inst_id; alter database recover managed standby database ca...