1. 确认ORA-10458和ORA-01152错误的具体含义 ORA-10458: "standby database requires recovery" 表示备库需要执行恢复操作。这通常发生在备库的数据文件与主库不同步时,或者备库在尝试访问的数据块在主库上已被修改但尚未传递到备库。 ORA-01152: "file 1 was not restored" 表示数据文件1(通常是系统数据文件)...
主:yoon 备:yoondg 备库: 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: '/opt/oracle/oradata/yoon/system01....
做dataguard,备库RMAN同步后alter database open read only发现起不来。rman过程并没有报错,启动备库的时候看alter.log有一堆Error 12154 received logging on to the standby,再看主库alter.log,也有一堆Error 12154 received logging on to the standby 这说明什么呢,说明archivelog归档到备库的路径是失败的,归...
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later: ORA-10458 ORA-01152 while bringing standby in READ ONLY mode
* 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/o1_mf_system_8v8y9m2x_.dbf'
Hello! I have restore my Database for standby and I couldn't open it and show the error: 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: '/data/DGRHEL21DB/datafile/o1_mf_system...
用rman恢复备库;遇到备库起不来一个案例 ORA-01152:ORA-01110 2015-10-22 18:52 −数据从主库恢复到备库;打开备库发现出现异常 SQL> alter database open; alter database open * ERROR at line 1: ORA-10458: standby database requires recovery ORA-0115... ...
51CTO博客已为您找到关于ora-10458 ora-01152 ora-01110的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及ora-10458 ora-01152 ora-01110问答内容。更多ora-10458 ora-01152 ora-01110相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。
ORA-16016: archived log for thread 1 sequence# 275451 unavailable ORA-10458: standby database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '+PUR_DATA01/fresa1p/datafile/system.277.949080601'...
数据库:oracle 11.2.0.4 主机名:主库leo-oel150 +备库leo-oel151 1、异常重现 SYS@orcl151> alter database open; alter database open * ERROR at line 1: ORA-10458: standby database requires recovery ORA-01152: file 4 was not restored from a sufficiently old backup ...