xushaonan001的博客

SQL> archive log list;Database log mode        Archive ModeAutomatic archival        EnabledArchive destination        USE_DB_RECOVERY_FILE_DESTOldest online log sequence     35Next log sequ

select * from v$archived_log;select * from v$log;select  file#,checkpoint_change# from v$datafile;select  file#,checkpoint_change# from v$datafile_header;select sequence#,FIRST_CHANGE#,NEXT_CH