ORA-01152错误是Oracle数据库中的一个常见错误,具体信息为“file 1 was not restored from a sufficiently old backup”。这个错误表明在尝试使用备份文件恢复数据库时,系统检测到指定的数据文件(在这个例子中是文件1,通常是系统表空间的数据文件)并不是从一个足够旧的备份中恢复的。这通常是因为恢复操作与备份的日...
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oracle/u01/app/oracle/oradata/orcl/system01.dbf' 这时已经报错ORA-01152,根据提示就是说使用了一个旧的控制文件。 通过B的方法恢复,应用归档。 h) 恢复数据库 这时有两种方法完成 i.在SQLPLUS中手动利用归...
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oracle/u01/app/oracle/oradata/orcl/system01.dbf' 这时已经报错ORA-01152,根据提示就是说使用了一个旧的控制文件。 通过B的方法恢复,应用归档。 h)恢复数据库 这时有两种方法完成 i.在SQLPLUS中手动利用归档...
数据库恢复后打开时遇到: RMAN> alter database open resetlogs;...ORA-01152: file 1 was not restored from a sufficiently old backupORA-01110: data file 1: '/oracle/u01/app/oracle/oradata/orcl/system01.dbf' 分析原因 oracle对于这个错误的解释是: ORA-01152: file 1 was not restored from a s...
异机恢复后ORA-01152错误解决 1.现象: 异机数据文件恢复成功后,执行最后一步打开数据库时报错。例如: SQL > alter database open resetlogs; 报错: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u02/oracle/oradata/mingya/system01.dbf'...
方法/步骤 1 ORA-01152: file 1 was not restored from a sufficiently old backup今天在备份数据时开启了自动备份控制文件所以控制文件也自动备份了 2 2.在没有删除控制文件的情况下，直接使用了备份的控制文件进行恢复 3 3.然后在打开数据库的时候发现无法正常打开 4 4.使用recover,restore对数据库进行恢复之后...
9:output filename=/u01/app/oracle/oradata/EPPS/control03.ctl 10:Finished restore at 02-APR-14 Step 5:将数据库启动到mount状态 RMAN> alter database mount; database mounted released channel: ORA_DISK_1 Step 6:restore 数据库(中间太多数据文件restore,使用...替代) 1:...
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/...
51CTO博客已为您找到关于ORA-01152: file 1 was not restored from a sufficiently old backup的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及ORA-01152: file 1 was not restored from a sufficiently old backup问答内容。更多ORA-01152: file 1 was not r
ERROR at line 1: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'L:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\SYSTEM01.DBF' SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile; ...