首先说,是否明白 alter database recover managed standby database disconnect from session; 这句话的作用。 其含义就是启动日志应用。 那么,open_mode 变成了 READ ONLY WITH APPLY 就可以理解了吧。To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement. For example: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; This statement starts a detached server process and immediately returns control to the user. While the managed recovery process is performing recovery in the background, the foreground process that issued the RECOVER statement can continue performing other tasks. This does not disconnect the current SQL session.
为什么OPEN_MODE从READ ONLY变成了READ ONLY WITH APPLY?
其含义就是启动日志应用。
那么,open_mode 变成了 READ ONLY WITH APPLY 就可以理解了吧。To start Redo Apply in the background, include the DISCONNECT keyword on the
SQL statement. For example:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
This statement starts a detached server process and immediately returns control to the user. While the managed recovery process is performing recovery in the
background, the foreground process that issued the RECOVER statement can continue performing other tasks. This does not disconnect the current SQL session.