切换备库从只读访问到重做应用:
Terminate all active user sessions on the standby database.
1.终止备库上所有活跃的用户会话。
Restart Redo Apply. To start Redo Apply, issue the following statement:
2.重启重做应用,发出以下语句可以启用重做应用:
To enable real-time apply, include the USING CURRENT LOGFILE clause:
实时应用,需要包含USING CURRENT LOGFILE子句:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 2> USING CURRENT LOGFILE;You do not need to shut down the instance to start either of these apply modes.
你不需要关闭数据库然后再启用这些应用模式。