Oracle Database: Flashback RAC Primary and Standby
In this blog I am going to discuss on how to flashback a RAC Primary and RAC Standby both and ensure Standby is in sync. These are for some maintenance activities you might want to perform on Primary and to have a rollback plan. My primary Database name is PRIM and Standby is STDBY. Step 1 and 2 are setup for the flashback. Step 1 - Stop the apply on STDBY dgmgrl / edit database 'STDBY' set state 'APPLY-OFF' Step 2 - Create GRP (Guaranteed Restore Point) i. Switch logfile on Primary (alter system archive log current) ii. Create GRP on Standby (Create Restore Point BEFORE_RELOAD GUARANTEE FLASHBACK DATABASE) iii. Create GRP on Primary (Create Restore Point BEFORE_RELOAD GUARANTEE FLASHBACK DATABASE) iv. take output of select * from v$restore_point and note the scn. Now do your changes (patching etc), assuming your changes were not successful and you want to rollback. Step 3 - Do the Flashback i. Stop Database Primary (srvctl stop database -d PRIM) ii. Start one