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 V$ARCHIVE_DEST_STATUS where DEST_ID =2;

On standby:
===========
SQL - select NAME, VALUE, DATUM_TIME from V$DATAGUARD_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 V$DATABASE;

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 V$DATABASE;

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 v$managed_standby;

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

[insanesamgaming]

This same steps work in Oracle 19c also ??