常用视图

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_CHANGE# FROM v$archived_log;