文档解释
ORA-16822: new primary database not yet ready for standby database reinstatement
Cause: The new primary database, as a result of a logical standby database failover operation, had not fully completed the failover operation. An attempt to reinstate a disabled standby database could not be completed until failover completed on the new primary database.
Action: Wait until the failover operation has completed on the new primary database. Then retry the reinstate operation.
ORA-16822错误是当你尝试恢复一个备份数据库时,主数据库还没准备好接受该备份数据库进行恢复上线时,会出现的一个错误。
官方解释
常见案例
一般处理方法及步骤
1.确保你的备份文件和主数据库之间存在一致性;
2.在备份数据库上执行“recover managed standby database”;
3.在主数据库中运行“alter database create standby controlfile as”来恢复控制文件;
4.运行“alter database recover managed standby database;”
5.设置预期的主数据库(主要的)的重新实例化参数;
6.最后,将备用数据库恢复到活动状态,通过运行“alter database activate physical standby database”完成;