文档介绍：DBA never sleep-DBA,永不眠
Focus on Oracle Database, GodenGate and Unix
[置顶] Oracle Active Data Guard 遇
ORA-10458、ORA-01152、ORA-01110 错误
分类: Oracle DataGuard Oracle Troubleshooting 2013-06-12 10:05 692人阅读评论(0) 收藏举报
Active Data GuardORA-10458ORA-01152ORA-
今天第一次配 Oracle 11g R2 Active Data Guard,在用 RMAN 创建好 physical standby database 后,
尝试将 standby 以 read only 方式打开时遇如下错误:
SQL> alter database open read only;
alter database open read only
*
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:
'/u01/app/oracle/oradata/STANDBY/datafile/'
metalink 文章[ID ]上描述是 primary database patible 参数设置错误
Primary:
SQL> col host_name for a20
SQL> select instance_name,host_name,version,archiver,log_switch_wait from v$instance;
INSTANCE_NAME    HOST_NAME            VERSION           ARCHIVE LOG_SWITCH_WAIT
---------------- -------------------- ----------------- ------- ---------------
prod             prod.              STARTED 
Standby:
SQL> select instance_name,host_name,version,archiver,log_switch_wait from v$instance;
INSTANCE_NAME    HOST_NAME            VERSION           ARCHIVE LOG_SWITCH_WAIT
---------------- -------------------- ----------------- ------- ---------------
standby          standby.