Oracle 不完整恢复产生ORA-01152

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

[oracle@vrh8 ~]$ oerr ora 1152
01152, 00000, “file %s was not restored from a sufficiently old backup ”
// *Cause: An incomplete recovery session was started, but an insufficient
// number of logs were applied to make the database consistent. This
// file is still in the future of the last log applied. The most
// likely cause of this error is forgetting to restore the file
// from a backup before doing incomplete recovery.
// *Action: Either apply more logs until the database is consistent or
// restore the database file from an older backup and repeat recovery

 

适用于:
Oracle Database – Enterprise Edition – Version 8.1.7.4 to 11.2.0.4 [Release 8.1.7 to 11.2]
本文信息适用于任何平台。

症状
在不完整恢复后,试图打开数据库获取ORA-1152 。
原因
当文件早于恢复停止点的时间(SCN),发生该错误。
解决方案
要实施该解决方案,执行以下步骤:

1. 找出哪个文件较新:
a. 启动mount 实例
b. 发出以下查询:
sql> select file#, status, checkpoint_change# from v$datafile;
sql> select file#, status, fuzzy, checkpoint_change# from v$datafile_header;

c. 查看checkpoint_change#,找出哪个文件相对其他文件较新。

2. 从之前的备份还原该文件。
3. 重新做不完整恢复

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号