DB Wiki

User Tools

Site Tools

Trace:
oracledataguard

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
oracledataguard [2016/12/20 10:53] – [SQL Scripts] z0hpvkoracledataguard [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 68: Line 68:
  
 -- Check if Real Time Apply is Enabled -- Check if Real Time Apply is Enabled
 +col DEST_NAME format a25
 select DEST_ID,dest_name,status,type,srl,recovery_mode  select DEST_ID,dest_name,status,type,srl,recovery_mode 
 from v$archive_dest_status  from v$archive_dest_status 
-where dest_id=1;</code>+where status <> 'INACTIVE';</code>
  
 ==== Switchover ==== ==== Switchover ====
Line 108: Line 109:
 PRIMARY: alter system set log_archive_trace=0; PRIMARY: alter system set log_archive_trace=0;
 STANDBY: alter system set log_archive_trace=0;</code> STANDBY: alter system set log_archive_trace=0;</code>
 +
 +==== Failover ====
 +https://docs.oracle.com/cd/E11882_01/server.112/e41134/role_management.htm#SBYDB4773
 +<code>
 +SELECT STATUS, INSTANCE_NAME, DATABASE_ROLE from V$DATABASE, V$INSTANCE;
 +
 +ALTER DATABASE RECOVER MANAGED DATABASE CANCEL;
 +ALTER DATABASE RECOVER MANAGED DATABASE FINISH;
 +
 +ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
 +ALTER DATABASE ACTIVATE STANDBY DATABASE;
 +ALTER DATABASE OPEN;
 +
 +SELECT STATUS, INSTANCE_NAME, DATABASE_ROLE from V$DATABASE, V$INSTANCE;
 +</code>
 +
 +
  
 ==== Active Data Guard ==== ==== Active Data Guard ====
oracledataguard.1482231233.txt.gz · Last modified: 2025/03/08 22:23 (external edit)