Oracle 11.2.0.4.0 Dataguard Deployment and routine maintenance (6)-active Dataguard

1. Check the status of the master standby library

• On primary

columndatabase_role Format A20columnopen_mode Format A15columnprotection_mode Format A20columnswitchover_status Format A20SelectDatabase_role,open_mode,protection_mode,switchover_status fromv$Database;D atabase_role open_mode protection_mode switchover_status-------------------- --------------- -------------------- --------------------PRIMARY          READWRITE MAXIMUM Performance toSTANDBYSelect Max(sequence#) fromV$archived_log;MAX(sequence#)--------------         the

• On standby

columndatabase_role Format A20columnopen_mode Format A15columnprotection_mode Format A20columnswitchover_status Format A20SelectDatabase_role,open_mode,protection_mode,switchover_status fromv$Database;D atabase_role open_mode protection_mode switchover_status-------------------- --------------- -------------------- --------------------Physical STANDBY mounted MAXIMUM performance notallowedSelectSequence#,applied fromV$archived_logwheresequence#=(Select Max(sequence#) fromV$archived_log); sequence# Applied---------- ---------------------------     the  　　 in-MEMORYSelectprocess,status,sequence# fromV$managed_standby; PROCESS STATUS sequence#------------------- ----------------------- ----------ARCH CLOSING theARCH CONNECTED0ARCH CONNECTED0ARCH CLOSING $RFS IDLE0RFS IDLE theRFS IDLE0MRP0 Applying_log the

2. Undo the MPR recovery thread for the standby library

Alter Database database Cancel;

3. The standby library opens in readonly mode

Alter Database Open Read  only;SelectDatabase_role,open_mode,protection_mode,switchover_status fromv$Database;D atabase_role open_mode protection_mode switchover_status-------------------- --------------- -------------------- --------------------Physical STANDBYREAD  onlyMAXIMUM Performance notallowedSelectprocess,status,sequence# fromV$managed_standby; PROCESS STATUS sequence#------------------- ----------------------- ----------ARCH CLOSING theARCH CONNECTED0ARCH CONNECTED0ARCH CLOSING $RFS IDLE0RFS IDLE theRFS IDLE0

4. Open the MPR thread of the standby library

Alter DatabaseRecover managed StandbyDatabaseUsing CurrentLogFile Disconnect fromsession;
Selectprocess,status,sequence# fromV$managed_standby; PROCESS STATUS sequence#------------------- ----------------------- ----------ARCH CLOSING theARCH CONNECTED0ARCH CONNECTED0ARCH CLOSING $RFS IDLE0RFS IDLE theRFS IDLE0MRP0 Applying_log the

5. Test the active Dataguard

• On primary

Create Tabletest01 as Select file_name  fromDba_data_files;Select *  fromtest01;file_name------------------------------------------------------------/U01/App/Oracle/Oradata/UserData/users01.dbf/U01/App/Oracle/Oradata/UserData/undotbs01.dbf/U01/App/Oracle/Oradata/UserData/sysaux01.dbf/U01/App/Oracle/Oradata/UserData/System01.dbf

• On standby

Select *  fromtest01;file_name------------------------------------------------------------/U01/App/Oracle/Oradata/UserData/users01.dbf/U01/App/Oracle/Oradata/UserData/undotbs01.dbf/U01/App/Oracle/Oradata/UserData/sysaux01.dbf/U01/App/Oracle/Oradata/UserData/System01.dbf

Oracle 11.2.0.4.0 Dataguard Deployment and ongoing maintenance (6)-active Dataguard