ORA-19943: The current database incarnation changed during backup ORACLE 报错 故障修复 远程处理

文档解释

ORA-19943: The current database incarnation changed during backup

Cause: The backup failed because the current database incarnation was changed during the backup. One of the following events caused this incarnation change:
– The database was opened using ALTER DATABASE OPEN RESETLOGS statement.
– RMAN command RESET DATABASE TO INCARNATION was issued.
– If this happened on physical standby database, then redo apply has applied redo data from a new database incarnation.

Action: Re-try the backup.

ORA-19943是一个备份时出现的错误，指RMAN执行备份操作时，当前数据库实例改变了自身状态。

官方解释

“ORA-19943: 在备份期间，当前数据库实例改变了自身状态”

常见案例

1.备份的状态和RMAN重新从存档日志恢复状态之间发生了变化

2.备份期间数据库状态发生了重大变化

一般处理方法及步骤

1.确定备份的时候数据库的状态是什么，针对不同的情况恢复成正确的数据库状态

2.可以重新启动RMAN恢复操作，检查数据库中断点repair failure

3.如果是由于系统更新导致，可以尝试用修复程序来应用更新信息，以保持RMAN恢复操作的一致性

4.如果是可恢复的，可以重新定位备份从哪里开始和你的数据库的当前状态之间的中断点，然后通过RMAN重新恢复数据