1. Check if they are in sync
primary:
alter system switch logfile;
select max(SEQUENCE#) from v$archived_log where applied='YES';
select max(SEQUENCE#) from v$archived_log where applied='YES';
2. Check if standby database are applying the log
SQL> select PROCESS,STATUS from v$managed_standby;
PROCESS STATUS
--------------------------- ------------------------------------
ARCH CLOSING
ARCH CONNECTED
ARCH CLOSING
ARCH CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG
8 rows selected.
3. Stop applying log
Alter database recovery managed standby database cancel;
4. Resume applying log
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
alter database recover managed standby database using current logfile disconnect from session;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10973950/viewspace-1061240/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10973950/viewspace-1061240/