OracleDataGuard_备库以只读或读写方式打开访问(三)

2014-11-24 09:16:38 · 作者: · 浏览: 1
ccess to performing Redo Apply:

切换备库从只读访问到重做应用:

Terminate all active user sessions on the standby database.

1.终止备库上所有活跃的用户会话。

Restart Redo Apply. To start Redo Apply, issue the following statement:

2.重启重做应用,发出以下语句可以启用重做应用:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 2> DISCONNECT FROM SESSION;

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.

你不需要关闭数据库然后再启用这些应用模式。