1. Check the status of the master standby library
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
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
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
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