ORA-19910: can not change recovery target incarnation in control file ORACLE 报错 故障修复 远程处理
文档解释
ORA-19910: can not change recovery target incarnation in control file
Cause: The RESET DATABASE TO INCARNATION command was used while the database is open. This is not allowed.
Action: Close the database then re-issue the command.
ORA-19910错误表明无法在控制文件中更改恢复目标化身。
官方解释
当您尝试在控制文件中更改恢复目标化身的设置时,会发生此错误,错误信息如下:
ORA-19910 cannot change recovery target incarnation in controlfile
常见案例
当完成快照恢复后,你尝试使用RMAN将恢复目标化身的设置重置到同一值,这可能会导致上述错误。
一般处理方法及步骤
要解决此错误,请按照以下步骤操作:
1、到您的重要恢复数据(CDF加载点),然后暂停恢复,例如:
RMAN> recover database until cancel;
2、清除所有操作,然后开始新的恢复会话:
RMAN> reset database;
3、改变恢复目标化身设置:
RMAN> set incarnation 1;
4、继续恢复数据库
RMAN> recover database;