Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about what it is like for 11g RAC to open the redo real-time application of DG. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

View the application of oracle master / slave logs:

SQL > select to_char (max (FIRST_TIME), 'HH24:MI:SS, yyyy-mm-dd') first_time from v$archived_log where applied='YES'

FIRST_TIME

-

20:57:52, 2018-07-22

Operate on DG:

SQL > select RECOVERY_MODE from v$archive_dest_status where rownum select group#,member from v$logfile order by 1; GROUP#

-

MEMBER

one

/ oracle/oradata/standby01.log 2

/ oracle/oradata/standby02.log 3

/ oracle/oradata/standby03.log

There is standby.log.

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

*

ERROR at line 1:

ORA-01153: an incompatible media recovery is active

Log synchronization needs to be disconnected first: SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

Database altered. SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

Database altered.

Yes.

SQL > select RECOVERY_MODE from v$archive_dest_status where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.