Oracle Data Guard Manual Switchover

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

[chakshujain]

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

[aniketbanerjee]

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-otwm]

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;

[rajatsanwal]

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>

[SMRUTI]

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

[muthukrishnan]

How to join by using indian credit card

[devidashalge]

I have doubt ..What i have to do when i got switchover status not allowed.