1. HOW TO PERFORM SWITCHOVER ACTIVE DATAGUARD ORACLE 12C DBA FROM INDIA

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

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

Perform Manual Switchover on Physical Standby

1 . Check primary and standby for any gaps

On primary:

SQL- select GAP_STATUS from VARCHIVE_DEST_STATUS where DEST_ID 2;

On standby:

SQL – select NAME, VALUE, DATUM_TIME from VDATAGUARD_STATS;

2. Convert primary to standby: We will first convert primary to standby and later standby to primary

On primary:

SQL – select SWITCHOVER_STATUS from VDATABASE;

You must see TO STANDBY

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

SQL- startup mount

Convert standby to primary: Our primary is already converted to standby. Now it’s time to convert original standby into primary

SQL- select SWITCHOVER_STATUS from VDATABASE;

SQL- alter database commit to switchover to primary with session shutdown;

SQL- alter database open;

On new standby – Initially your primary database: Start MRP

SQL- alter database recover managed standby database disconnect;

select process, status, sequence# from vmanaged_standby;

#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 *