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博客 ” ，链接：https://blog.itpub.net/10973950/viewspace-1061240/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
