查看select 3

s 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#,status,member from v$logfile;
select group# from v$log;
select * from v$logfile;
 select members from v$log;查看成员
alter system switch logfile;强制切换日志
alter system checkpoint; 强制检查点
alter database add logfile group 4 建立组
 alter database drop logfile member 删除成员
alter database rename file '/oradata/ts_db/system01.dbf' to '/oracle/ts_db/syste
m01.dbf';
归档文件
startup mount;
archive log list;列表
alter database archivelog;改为归档