How To Flashback Primary Database In Standby Configuration

Goal

How to flashback primary database in standby configuration.

Solution

To Flashback primary database execute following steps :

1. Shutdown primary database .

SQL> SHUTDOWN IMMEDIATE

1. Start primary database in mount stage

SQL> STARTUP MOUNT

1. Flashback primary database to specified scn

SQL> FLASHBACK DATABASE TO SCN <scn_number>;

1. Open primary database with reset logs.

SQL> ALTER DATABASE OPEN RESETLOGS;

1. Cancel media recovery on the standby database.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

1. Check current_scn on the standby database, If flashback scn is greater then current_scn then skip next step (step 7).

SQL> SELECT CURRENT_SCN FROM V$DATABASE;

1. Flashback Standby database

SQL> FLASHBACK STANDBY DATABASE TO SCN <scn_number -2>; (on standby database)

1. Start managed recovery on the standby database

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;