DB Wiki

User Tools

Site Tools

Trace: • grandnationalpostgresql
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/08/11 09:28] – z0hpvkoracledataguard [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 65: Line 65:
 select timestamp, facility, severity, message select timestamp, facility, severity, message
 from v$dataguard_status from v$dataguard_status
-order by timestamp;</code>+order by timestamp; 
 + 
 +-- Check if Real Time Apply is Enabled 
 +col DEST_NAME format a25 
 +select DEST_ID,dest_name,status,type,srl,recovery_mode  
 +from v$archive_dest_status  
 +where status <> 'INACTIVE';</code>
  
 ==== Switchover ==== ==== Switchover ====
Line 103: 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.1470907690.txt.gz · Last modified: (external edit)