High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center