data guard - Check redo transport lag and apply lag in standby database

-- Check redo transport lag and apply lag in standby database

# standby

  

  archive log list

  

  col name for a13

  col value for a20

  col unit for a30

  set lines 122

  select name, value, unit, time_computed from v$dataguard_stats where name in ('transport lag','apply lag');

Recovering Standby Database - Archive log missing from Standby

on PRIMARY:
mkdir /u01/scott

rman target /
RMAN> list archivelog all;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
9833 2 4553 A 07-NOV-11 +FRA1/demo/archive_logs/2_4553_621298904.dbf
exit


sqlplus / as sysdba
CREATE OR REPLACE DIRECTORY log_files AS '+FRA1/demo/archive_logs' ;
CREATE DIRECTORY DSK_FILES AS '/u01/scott';
exec DBMS_FILE_TRANSFER.COPY_FILE ( 'log_files' , '2_4553_621298904.dbf' , 'dsk_files' , '2_4553_621298904.dbf' );

on STANDBY:
mkdir /u01/scott
cd /u01/scott
scp PRIMARY_HOST_IP_ADDRESS:/u01/scott/2_4553_621298904.dbf .
rman target /
RMAN> CATALOG ARCHIVELOG '/u01/scott/2_4553_621298904.dbf';
RMAN> list archivelog all;
exit;

Data Guard - How To Check Whether Physical Standby is in Sync with the Primary or Not?

Summary

1. Check for GAP on standby

2. Check redo received on standby

3. Check redo applied on standby

4. Identify missing archive log files

5. Copy archive log files

6. Register archive log files with standby

7. Restart the managed recovery operations

Dataguard a case study - what to do when Primary database is lost ?

# Case Study - Primary Is Lost

Summary

1. managed standbt database finsh

2. activate physical standby database

3. open database

DataGuard switchover

Summary

1. stop/suspend schedule jobs

2. Switchover Primary database role

3. Switchover Standby database role

4. Check Primary and Standby are in sync