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;改为归档
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;改为归档