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中手动利用归档...
1 ORA-01152: file 1 was not restored from a sufficiently old backup今天在备份数据时开启了自动备份控制文件所以控制文件也自动备份了 2 2.在没有删除控制文件的情况下，直接使用了备份的控制文件进行恢复 3 3.然后在打开数据库的时候发现无法正常打开 4 4.使用recover,restore对数据库进行恢复之后依然无法正常...
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/../../raw12' 造成这种报错的大部分原因是因为controlfile里所记录的scn与datafile里的scn不一致。比如从备份里restore出的controlfile上的scn < datafile上所记录的scn,因此理论上二种思路: ...
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' ...
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 sufficiently old backupCause...
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/opt/oracle/oradata/ge/system01.dbf' 在打开数据库的时候出现上面的错误,解决过程如下: 错误原因分析: 是由于controlfile里所记录的scn与datafile里的scn不一致。比如从备份里restore出的controlfile上的scn < ...
Hi All, I have Oracle 11g R2 running on CentOS 6, 64bit env. I have a standby database that has fallen behind and we have lost the archive logs. Strangly though, the cron jobs applying the logs reports that standby database is only 606 logs behind - which for our load is about 2...
ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oracle/product/10.2.0/oradata/orcl/system01.dbf' RMAN> restore datafile 9; Starting restore at 06-JAN-11 using channel ORA_DISK_1 creating datafile fno=9 name=/oracle/product/10.2.0/oradata/...