Wednesday, January 16, 2008

Show archive logfiles sequence

Quick SQL to see if your archive log had been applied:
 
SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

No comments: