Flashback Database to Restore Point in Primary-Standby Environment
Flashback Database to Restore Point in Primary-Standby Environment: When we have a Data Guard environment (Primary RAC and Standby Standalone Databases) and we want Flashback database to restore point. We need to follow below steps. a) Always flashback the primary database first. Then follow below step for Standby. b) On the primary, connect using RMAN and list the incarnations. c) On the standby, cancel the recovery and flashback the standby to restore point created earlier. d) On the standby, connect using RMAN and list the incarnations. e) If there is a mismatch in incarnation between primary and standby then need to reset the incarnation of standby and start recovery (Details not available in this DOC). 1) Disable Log Transport Services to the Standby Database for the Destination serving the Standby Database on all Primary Instances: $ dgmgrl sys/<Password>@<PRIM/STDBY> DGMGRL> show database 'PRIM '; edit database...