• 问题及现象
• 解决方法
  • 1.从库启动到mount状态
  • 2.主库上操作
  • 3.备库操作

问题及现象

11g搭建完备库后，打开备库时报错，如下：

SQL> alter database recover managed standby database cancel;

Database altered.

SQL>  alter database open;

 alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+ORADATA/racdg/datafile/system.260.1000300965'

解决方法

1.从库启动到mount状态

SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT;
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USEING CURRENT LOGFILE DISCONNECT FROM SESSION;

2.主库上操作

SQL>ALTER SYSTEM SWITCH LOGFILE;
多操作几次，操作之后，稍等一段时间，时间视网速而定，过一段时间后，在主库上查询一下规定情况：
SQL>SELECT NAME,SEQUENCE#,ARCHIVED,APPLIED FROMV$ARCHIVED_LOG ORDER BY SEQUENCE#;
如果返回结果"APPLIED"都是“YES”或者只有最后一个是“NO”的话，说明全部归档日志全部已经归档完了，此时到备库上上操作

3.备库操作

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;