Turn Flashback on after start of managed recovery


To make Database flashback on Standby, use following command.

Issue the following query to find out if the standby database is performing Redo Apply or. real-time apply. If the MRP0 or MRP process exists, then the standby database is applying redo.

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
ƒ If log apply services are running, cancel them as shown in the following command
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE FLASHBACK ON;
ƒ Restart Redo Apply or real-time apply. To start Redo Apply, issue the following statement:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
OR
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT NODELAY;
OR
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
ƒ To test the archived logs are being applied of not on standby.
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDERBY
SEQUENCE#;
SQL> SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS;
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER
 BY SEQUENCE#;

You will notice the sequence# is advanced in both primary and standby.
ƒ If DGMGRL was already configured there will warning which can be fixed by enabling and disabling
configuration
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
DGMGRL> Disable Configuration
DGRMGRL> Enable Configuration
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: