ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo.
Cause: An attempt was made to perform block media recovery on the standby database when the necessary redo was not available.
Action: Wait until the necessary redo is available and reattempt block media recovery.
操作
ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo.
这是一个在块媒体恢复期间可能出现的错误。这通常发生在受控环境下，这意味着一个活动数据库和一个备份数据库。该错误的官方描述如下：
ORA-10546: “Cannot perform block media recovery – standby database does not have requisite redo.”
1. 运行数据库恢复管理器(DBRM)，从活动数据库的redo日志中追溯redolog信息，然后关联到受控备份库。
2. 恢复数据库，以确保redo日志和备份日志保持一致
3. 在受控备份数据库上操作，以便确定数据库块的初始内容
4. 将redo日志从活动数据库应用到受控备份数据库，从而确保redo日志与受控备份库保持一致
5. 将受控备份库恢复到一致性点，以恢复块媒体
6. 激活受控备份数据库，并且确保它正确无误运行