Oracle Data Guard (ODG) Management During Outage in SAP Production Server & DR Server

 Oracle Data Guard (ODG) Management During Outage in SAP Production Server & DR Server

----------------------------------------------------------------------------     
                Before Outage :
----------------------------------------------------------------------------

In Production
=============
1) SQL>alter system set log_archive_dest_state_2 = 'defer';

In DR
=====
2) SQL> alter database recover managed standby database cancel;
   SQL> shutdown immediate;

---------------------------------------------------------------------------
            After Outage :
---------------------------------------------------------------------------

In Production
=============

1) SQL> alter system set log_archive_dest_state_2 = 'enable';

In DR
====
2) SQL> startup nomount;
   SQL> alter database mount standby database;
   SQL> alter database recover managed standby database disconnect from session;

In Production
=============

3) SQL> select status, error from v$archive_dest where dest_id=2;

The value should be "Valid". It will take some time to show the value as "Valid".
------------------------------------------------------------------------------
            DR Sync Checking
-----------------------------------------------------------------------------
In DR
====
To check the DR Sync :

SQL> set linesize 80;
SQL> column name format a60;
SQL> select name,sequence#,archived,applied from v$archived_log order by sequence#;

SQL> select process,status from v$managed_standby;

SQL> select message from v$dataguard_status;