DG standby库v$standby_log视图异常
备库修改standb log文件位置后查询v$standby_log报错
SQL>select * from v$standby_log
ORA-00314: log 9 of thread 1, expected sequence# 706 doesn't match 704
ORA-00312: online log 9 thread 1: '/u02/oradata/center/standby_log/redo09_1.log'
ORA-00314: log 9 of thread 1, expected sequence# 706 doesn't match 704
ORA-00312: online log 9 thread 1: '/u02/oradata/center/standby_log/redo09.log'
查看当前应用的日志序列
SQL> select max(SEQUENCE#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
721
且主从同步正常。
解决方法
alter database clear logfile group 9;
清空日志组9的内容
清空后查询v$standby_log正常
SQL>select * from v$standby_log
ORA-00314: log 9 of thread 1, expected sequence# 706 doesn't match 704
ORA-00312: online log 9 thread 1: '/u02/oradata/center/standby_log/redo09_1.log'
ORA-00314: log 9 of thread 1, expected sequence# 706 doesn't match 704
ORA-00312: online log 9 thread 1: '/u02/oradata/center/standby_log/redo09.log'
查看当前应用的日志序列
SQL> select max(SEQUENCE#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
721
且主从同步正常。
解决方法
alter database clear logfile group 9;
清空日志组9的内容
清空后查询v$standby_log正常
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26794255/viewspace-1299214/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
