Active DG and Flashback with GRP
Hey guys
For some compression tests porposes we are going to use our Reporting database or Active DG to tests
In order to get these tests possible without touch our Prod primary database; we want to setup flashback in our Active DG database
these are the step I"m thinking to do
SQLPLUS> shutdown immediate
SQLPLUS> startup mount
###SQLPLUS> alter system set dg_broker_start=FALSE;
SQLPLUS> select current_scn from v$database;
SQLPLUS> alter database recover managed standby database cancel;
SQLPLUS> shutdown immediate
SQLPLUS> startup mount
SQLPLUS> alter database flashback on;
SQLPLUS> create restore point BEFORE_COMPRESS_TESTS guarantee flashback database;