Top Oracle Data guard queries
Top Oracle Data guard queries
Here are some of the Top Oracle data guard queries How to check the archive log sequence on Primary Side SELECT THREAD# "Thread",SEQUENCE# "Last Sequence Generated" FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#) ORDER BY 1; How to check the archive log sequence apply status on Standby Side SELECT ARCH.THREAD# "Thread",…
View On WordPress










