备库启动遇到问题

SQL> startup

ORA-10458: standby database requires recovery

ORA-01196: file 1 is inconsistent due to a failed media recovery session

ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'

原因是由于某些redo没有传输到备库，可能落后了很多归档文件

处理：

1)备库查询：SQL>select process,client_process,sequence#,status from v$managed_standby;//定位正在应用的日志文件

select max(sequence#) from v$archived_log;

2)主库查询：SQL> select process,client_process,sequence#,status from v$managed_standby;//查询主库当前写到的日志文件

select max(sequence#) from v$archived_log;

3)对比备库与主库之间的待传输应用日志文件，从主库拷贝到备库归档路径

4)备库注册

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/app/oracle/archivelog/xxx.dbf' ;

5)备库应用redo

alter database recover managed standby database disconnect from session;

即可。

ITPub博客

Oracle 11g R2 DG 备库启动报错，需要恢复日志处理措施