select member from v$logfile;
desc v$log
select status from v$log;
select member from v$logfile;
select archive form v$instance;
archive log list;
alter system checkpoint;
select member from v$logfile;
select group#,status,members from v$log;
select group# from v$log;
select * from v$logfile;
select members from v$log;
desc v$log
select status from v$log;
select member from v$logfile;
select archive form v$instance;
archive log list;
alter system checkpoint;
select member from v$logfile;
select group#,status,members from v$log;
select group# from v$log;
select * from v$logfile;
select members from v$log;