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];
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;
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>
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
You really teach us in very simple way. Thank you Arun sir.
It's my pleasure
Great video
Glad you enjoyed it
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];
Thank you!
Welcome!
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;
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>
I have doubt ..What i have to do when i got switchover status not allowed.
wait for a min and re-query 😜.. It take little time for status to change 👍
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
How to join by using indian credit card