Checking method of data synchronization of oracle11g Dataguard standby Library

Overview:

First, Environment Main library: IP address: 192.168.122.203 Oracle root directory:/data/db/oracle sid:qyq data File path/data/db/oracle/oradata/qyq Archive file path:/data/db/oracle/archive '
Standby Library: IP address: 192.168.122.204 Oracle root directory:/data/app/oracle sid:qyq data file path/DATA/APP/ORACLE/ORADATA/QYQ archive File path:/data/app/oracle/archive '
Second, the problem check method of the standby library is not synchronized

1. Check the serial number on both sides of the main preparation
Select Max (sequence#) from V$log; ---check found consistent

2, prepare the library execution, to see if there is no data applied
Select Name,sequence#,applied from V$archived_log order by sequence#;

Select Sequence#,first_time,next_time, applied from V$archived_log order by 1;

3. Check if the repository is open for real-time applications
Select Recovery_mode from V$archive_dest_status where dest_id=2;

4. Check the status of the standby library
Select Switchover_status from V$database; --Discover status not allowed

3. See if the process MRP exists
PS Aux|grep MRP--discovery process does not exist

4. Perform the following if it does not exist:
ALTER DATABASE recover managed standby database using current logfile disconnect;

ALTER DATABASE recover managed standby database disconnect from session; --Background execution

ALTER DATABASE recover managed standby database--The foreground execution, this can see the error situation

If there is an error, check the alert log and Log.xml log

5, verify whether normal
Select Process,status from V$managed_standby;
Select process,status,sequence# from V$managed_standby;

If you see Mrp0 normal

6, the above steps after processing, if the data is not normal, and then processing

Close the repository and proceed with:
The undotbs01.dbf file on the main library, the physical re-copy to the standby machine in the previous UNDOTBS01.DBF directory;

$SCP/data/oracle/oradata/voip/undotbs01.dbf 192.168.122.204:/data/oracle/oradata/voip

Re-generate a standby control file on the main library, copy it to the corresponding directory on the standby machine,

ALTER DATABASE create standby Controlfile as '/data/oracle/oradata/voip/qyqdg01.ctl '

$SCP/data/oracle/oradata/voip/qyqdg01.ctl 192.168.122.204:/data/oracle/oradata/voip
$ mv Qyqdg01.ctl Control01.ctl
$ CP control01.ctl/data/oracle/flash_recovery_area/qyq/
$CD/data/oracle/flash_recovery_area/qyq/
$ mv Control01.ctl Control02.ctl

Then
STARTUP Nomount;
ALTER database MOUNT STANDBY DATABASE;
ALTER database RECOVER MANAGED STANDBY database DISCONNECT from SESSION;

--------------------------------------
After the session recovery is complete, reboot to open the standby library;

ALTER DATABASE open read only;

Checking method of data synchronization of oracle11g Dataguard standby Library