-
Recent Posts
Recent Comments
Archives
- November 2019
- August 2016
- July 2016
- March 2016
- February 2015
- November 2014
- October 2014
- August 2014
- May 2014
- February 2014
- January 2014
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- June 2012
- January 2012
- December 2011
- November 2011
- June 2011
- May 2011
- March 2011
- January 2011
- December 2010
- May 2010
- April 2010
Categories
Meta
Click here :: like us on facebook
VISITORS
- 121,514 HITS
Monthly Archives: November 2019
Oracle DataGuard Basic commands
To check Gap in standby & run in standby database set lines 200 pages 100SELECT ‘Thread-‘||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 … Continue reading
Posted in Uncategorized
Leave a comment