Oracle 不完整恢复导致ORA-01152

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

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

服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]

ORA-01152 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.

APPLIES TO:

Oracle Database – Enterprise Edition – 版本8.1.7.4到 11.2.0.4 [Release 8.1.7 到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. 重新发出不完整恢复。