2. HOW TO PERFORM SWITCHBACK ACTIVE DATAGUARD ORACLE 12C DBA FROM INDIA

Channel Avatar
Comment
X
Share
2. HOW TO PERFORM SWITCHBACK ACTIVE DATAGUARD ORACLE 12C DBA FROM INDIA
2. HOW TO PERFORM SWITCHBACK ACTIVE DATAGUARD ORACLE 12C DBA FROM INDIA
Hi There

In this video I have tried to explain about the manual switchback activity in ACTIVE DATA GUARD environment. Below are given steps.
If you find this video helpful LIKE SHARE & SUBSCRIBE

SWITCH BACK

PRECHECKS :

nodeone:

select name,open_mode,database_role from vdatabase;

nodetwo:

select name,open_mode,database_role from vdatabase;

nodetwo :
select STATUS, GAP_STATUS from VARCHIVE_DEST_STATUS where DEST_ID 2;

nodeone:

select NAME, VALUE, DATUM_TIME from VDATAGUARD_STATS;

nodetwo:

select SWITCHOVER_STATUS from VDATABASE;

alter database commit to switchover to physical standby with session shutdown;

startup mount

nodeone:
select SWITCHOVER_STATUS from VDATABASE;

alter database commit to switchover to primary with session shutdown;

alter database open;

nodetwo:

alter database recover managed standby database disconnect;

#oracle #oracledba #oracledatabasetutorial #oracle12c #oracle19c #oracle11g

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *