Enable the real-time apply in 10G-优快云博客

本文链接：https://blog.youkuaiyun.com/henrybai/article/details/6135783

本文介绍如何在Oracle数据库中启动实时应用恢复，并解决在尝试使用当前日志文件断开连接进行恢复时遇到的ORA-01153错误。通过关闭当前的恢复进程，成功实现了数据库的实时应用恢复。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

If you want the redo data to be applied as it is received without waiting for the current standby redo log file to be archived, enable the real-time apply.

To start real-time apply:
SQL> alter database recover managed standby database using current logfile disconnect;

But Maybe you will encourter the error like this:

SQL> startup mount;
ORACLE instance started.

Total System Global Area  196681728 bytes
Fixed Size                  1298836 bytes
Variable Size             104861292 bytes
Database Buffers           83886080 bytes
Redo Buffers                6635520 bytes
Database mounted.
SQL> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect;

*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

Use the following command to close the process first.

SQL> alter database recover managed standby database cancel
  2  ;

Database altered.
You can view if the recover process is kicked off.
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS
  2  FROM V$MANAGED_STANDBY;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH      CONNECTED             0          0          0          0
ARCH      CLOSING               1         59          1        246
ARCH      CONNECTED             0          0          0          0
ARCH      CONNECTED             0          0          0          0
MRP0      WAIT_FOR_LOG          1         60          0          0
RFS       IDLE                  1         60        827          6
RFS       IDLE                  0          0          0          0
RFS       IDLE                  0          0          0          0
RFS       IDLE                  0          0          0          0

9 rows selected.