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 11:05] – [SQL Scripts] z0hpvkoracledataguard [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 109: 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.1482231924.txt.gz · Last modified: 2025/03/08 22:23 (external edit)