Steps to use Guaranteed Restore Points for backouts of database changes in a dataguard broker environment Failover Create the restore point on the failover databaase first, if there is addtional standby’s do the same on each standby SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; SQL>create restore point AT_test GUARANTEE FLASHBACK DATABASE; SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE […]

Steps to flashback the primary and stanby database to a point in time. Disable dataguard configuration dgmgrl show configuration – check no errors before starting this disable FAST_START FAILOVER; DISABLE CONFIGURATION; Primary srvctl stop database -d PTEST1 srvctl start database -d PTEST1 -o mount SQL>flashback database to timestamp to_timestamp(‘2011-02-17 14:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) or restore point […]