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/08/11 08:44] – 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 73: Line 79:
 The example below assumes a 2 Node RAC system using 10gR2.\\ The example below assumes a 2 Node RAC system using 10gR2.\\
 Primary Database: DBPRIM\\ Primary Database: DBPRIM\\
-Standby Database: DBSTBY+Standby Database: DBSTBY\\ 
 + 
 +<code>PRIMARY: alter system set log_archive_trace=8191; 
 +STANDBY: alter system set log_archive_trace=8191; 
 + 
 +PRIMARY: srvctl modify database -d DBPRIM -s mount 
 +STANDBY: srvctl modify database -d DBSTBY -s open 
 + 
 +PRIMARY: select switchover_status from v$database; (Value should say TO_STANDBY or SESSIONS_ACTIVE) 
 +PRIMARY: srvctl stop instance -d DBPRIM -i DBPRIM2 
 +PRIMARY: alter system archive log current; 
 + 
 +STANDBY: srvctl stop instance -d DBSTBY -i DBSTBY2 
 + 
 +PRIMARY: alter database commit to switchover to physical standby with session shutdown; 
 + 
 +STANDBY: select switchover_status from v$database; (Value should say TO_PRIMARY or SESSIONS_ACTIVE) 
 +STANDBY: alter database commit to switchover to primary; 
 +STANDBY: alter database open; 
 +STANDBY: srvctl start instance -d DBSTBY -i DBSTBY2 
 + 
 +PRIMARY: shutdown immediate; 
 +PRIMARY: srvctl start database -d DBPRIM 
 +PRIMARY: alter database recover managed standby database using current logfile disconnect; 
 + 
 +STANDBY: srvctl modify database -d DBSTBY -r primary 
 +PRIMARY: srvctl modify database -d DBPRIM -r physical_standby 
 + 
 +PRIMARY: alter system set log_archive_trace=0; 
 +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>
  
  
oracledataguard.1470905050.txt.gz · Last modified: 2025/03/08 22:23 (external edit)