DB Wiki

User Tools

Site Tools

Trace: • multitenantarchitecture • unifiedauditing
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 [2019/07/26 15:15] – z0hpvkoracledataguard [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 111: Line 111:
  
 ==== Failover ==== ==== Failover ====
 +https://docs.oracle.com/cd/E11882_01/server.112/e41134/role_management.htm#SBYDB4773
 <code> <code>
 SELECT STATUS, INSTANCE_NAME, DATABASE_ROLE from V$DATABASE, V$INSTANCE; SELECT STATUS, INSTANCE_NAME, DATABASE_ROLE from V$DATABASE, V$INSTANCE;
Line 118: Line 119:
  
 ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN; ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
 +ALTER DATABASE ACTIVATE STANDBY DATABASE;
 ALTER DATABASE OPEN; ALTER DATABASE OPEN;
  
 SELECT STATUS, INSTANCE_NAME, DATABASE_ROLE from V$DATABASE, V$INSTANCE; SELECT STATUS, INSTANCE_NAME, DATABASE_ROLE from V$DATABASE, V$INSTANCE;
 </code> </code>
 +
  
  
oracledataguard.1564154100.txt.gz · Last modified: 2025/03/08 22:23 (external edit)