ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby
Cause: The command was not permitted because the controlfile indicates the database was in the process of becoming a logical standby database but the controlfile conversion had not completed.
Action: If in the process of creating a logical standby database, perform the remaining instantiation procedures to completion. If this flashback operation followed a Data Guard failure, permit the errant Data Guard operation to successfully complete. Once the instantiation is complete, reissue the flashback operation.
ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby 错误指出,在逻辑备份实例化时不允许进行 FLASHBACK DATABASE 操作。
ORA-38860 不允许在逻辑备份实例化期间使用 “FLASHBACK DATABASE” 命令。这是由于在恢复备份后所需的重做日志暂停进行同步,逻辑备份应该反映主备份的将全量恢复之后的状态。
一个最常见的用例是当恢复一个备份和逻辑备份时,该语句可能在错误日志中显示,并显示 ORA-38860 错误。
如果有一个 ORA-38860 错误出现在数据库的错误日志中,唯一的正常处理方法就是在未禁止 FLASHBACK DATABASE 的情况下,完整初始化你的逻辑备份。
1. 使用数据库备份将主备份的实例恢复到恢复点(可选)。
2. 将你的备份数据文件删除掉,并重新建立一个逻辑备份实例。
3. 使用任务管理器或 RMAN 从主备份上复制重做日志到逻辑备份上。
4. 启动 FLASHBACK DATABASE 会话,按照你需要的要求设置一个初始化点。
5. 启动你的逻辑备份实例,并从这个初始化点开始实例化。