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/03/13 12:48] – [SQL Scripts] z0hpvkoracledataguard [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 4: Line 4:
 <code>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; <code>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
 +ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 240 DISCONNECT FROM SESSION;
 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;</code> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;</code>
  
Line 64: 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 ==== 
 +If the database you are using RAC and the database version is 11gR2 or less then you need to shut down all database instances apart from the first one before doing a switchover.\\ 
 +This is not neccessary any more in 12c. 
 + 
 +The example below assumes a 2 Node RAC system using 10gR2.\\ 
 +Primary Database: DBPRIM\\ 
 +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> 
 + 
  
 ==== Active Data Guard ==== ==== Active Data Guard ====
oracledataguard.1457873315.txt.gz · Last modified: 2025/03/08 22:23 (external edit)