Скачать с ютуб 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 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