Oracle Data Guard Manual Switchover

Подписаться 37 тыс.

Просмотров 15 тыс.

50% 1

Switchover can be done without #dataguard. Using #switchover operation we can convert physical #standby #database to primary and #primary database to physical standby database in #Oracle. Switchover operation can be performed without dataguard and with dataguard.
There is no #data loss during a switchover. After a switchover, each database continues to participate in the Data Guard configuration with its new role.
00:00 Perform manual switchover
04:10 Switchover configuration
05:31 Check primary and standby for gap
07:15 Convert primary to standby
11:08 Execute query on client
11:22 Convert standby to primary
12:00 Check client query
16:18 Get back to original setup
19:13 Edit TNS entries-example
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

Наука

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@chakshujain7246 11 месяцев назад

You really teach us in very simple way. Thank you Arun sir.

@dbagenesis 10 месяцев назад

It's my pleasure

@basar2030 2 года назад

Thank you!

@dbagenesis 2 года назад

Welcome!

@aniketbanerjee6377 4 года назад

Hey Arun , Thanks for posting such informative tutorial video .Just one suggestion would like to put is 1.We can omit the option of WITH SESSION SHUTDOWN as it will work 2.Also as stated below to simply in one command "ALTER DATABASE SWITCHOVER TO Test_s [FORCE] [VERIFY];

@sunilkumar-ot6wm 4 года назад

Nice explanation. I see that you are in 12.2 I think there is improved switchover command in 12.2 SQL>ALTER DATABASE SWITCHOVER TO Test_s verify; (To verify if all is good) and then do the actual switchover with one command SQL>ALTER DATABASE SWITCHOVER TO Test_s;

@ariaseraj4005 2 года назад

Great video

@dbagenesis 2 года назад

Glad you enjoyed it

@rajatsanwal9919 2 года назад

Arun Sir, Can you suggest here, what went wrong ? Database did not shut down after issuing alter database command. SQL> alter database commit to switchover to physical standby with session shutdown; Database altered. SQL> SQL> SQL> startup mount; ORA-01081: cannot start already-running ORACLE - shut it down first SQL>

@SMRUTI91 4 года назад

Could you please suggest which statement is supposed to use to verify the Gap in Standby: 1. select process, status, sequence# from v$managed_standby; or 2. SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1; Seems the second statement not giving correct result, it's showing difference but the 1st statement shows it's Closed