dataguard主备库同步问题,

[kanglehao]

不知道怎么整的~做好的dataguard
备库突然没法启动了,启动报错
SQL> startup
ORACLE instance started.

Total System Global Area 1536602112 bytes
Fixed Size 2213616 bytes
Variable Size 922749200 bytes
Database Buffers 603979776 bytes
Redo Buffers 7659520 bytes
Database mounted.
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/opt/oracle/db02/oradata/ORCL/system01.dbf'


然后查看日志应用情况

主库 上 select name,SEQUENCE#,APPLIED from v$archived_log order by name ,sequence# ;

/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_85.log 85 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_86.log 86 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_87.log 87 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_88.log 88 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_89.log 89 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_90.log 90 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_91.log 91 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_92.log 92 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_93.log 93 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_94.log 94 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_95.log 95 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_96.log 96 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_97.log 97 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_98.log 98 NO
/data/CEBPM/archivelogarch_4fe2d47c_1_812484863_99.log 99 NO
cebpms 85 YES
cebpms 86 YES
cebpms 87 YES
cebpms 96 NO
cebpms 96 NO
cebpms 97 NO
cebpms 98 NO
cebpms 99 NO


备库上
SQL> select name,SEQUENCE#,APPLIED from v$archived_log order by name ,sequence# ;

NAME
--------------------------------------------------------------------------------
SEQUENCE# APPLIED
---------- ---------
/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_85.log
85 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_86.log
86 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_87.log
87 YES


NAME
--------------------------------------------------------------------------------
SEQUENCE# APPLIED
---------- ---------
/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_88.log
88 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_89.log
89 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_90.log
90 YES


NAME
--------------------------------------------------------------------------------
SEQUENCE# APPLIED
---------- ---------
/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_91.log
91 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_92.log
92 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_93.log
93 YES


NAME
--------------------------------------------------------------------------------
SEQUENCE# APPLIED
---------- ---------
/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_94.log
94 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_95.log
95 YES

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_96.log
96 NO


NAME
--------------------------------------------------------------------------------
SEQUENCE# APPLIED
---------- ---------
/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_96.log
96 NO

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_97.log
97 NO

/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_98.log
98 NO


NAME
--------------------------------------------------------------------------------
SEQUENCE# APPLIED
---------- ---------
/data/CEBPMS/archivelog/arch_4fe2d47c_1_812484863_99.log
99 NO


100 rows selected.
请大神帮忙看下,这个如何处理~~还有主库上为什么有那么多NO的??但是之前同步是正常的

[学海无涯-回头是岸]

启动到mount状态

[kanglehao]

引用 1 楼 baidu_36457652 的回复:

启动到mount状态

试过了以下方法,并没有解决问题,我看上面96号日志有重复,搞不懂~ 从库启动到mount状态： SQL>SHUTDOWN IMMEDIATE SQL>STARTUP MOUNT; SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USEING CURRENT LOGFILE DISCONNECT FROM SESSION; 到主库上操作： SQL>ALTER SYSTEM SWITCH LOGFILE; 多操作几次，操作之后，稍等一段时间，时间视网速而定，过一段时间后，在主库上查询一下规定情况： SQL>SELECT NAME,SEQUENCE#,ARCHIVED,APPLIED FROMV$ARCHIVED_LOG ORDER BY SEQUENCE#; 如果返回结果"APPLIED"都是“YES”或者只有最后一个是“NO”的话，说明全部归档日志全部已经归档完了，此时到备库上上操作： 备库操作： SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCLE; SQL>ALTER DATABASE OPEN; SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

[学海无涯-回头是岸]

没有启动得了 是standby 吗？ 还是说 日志应用不了?

[kanglehao]

引用 3 楼 baidu_36457652 的回复:

没有启动得了 是standby 吗？ 还是说 日志应用不了?

standby启动不了,standby可以启动到mount状态 ,但是查看日志还是没有应用

[学海无涯-回头是岸]

能切到管理模式吗？ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;