oracle logfile ssd,oracle logfile

强制切换联机重做日志

desc v$log

alter system switch logfile;

select group#, thread#,sequence#, status from v$log;

强制执行检查点

alter system checkpoint;

增加 redo files groups (组)

desc v$logfile

select * from v$logfile;

alter database add logfile group 3

('/u01/oradata/wilson/redo03.log') size 100M;

实际生产环境之中至少一个group里面有两个member 以防单点故障

若一member为invalid则此redo logfile不可用

往组里面增加成员(member)

alter database add logfile member

'/u01/oradata/wilson/redo03a.log' to group 3;

select * from $logfile;

将往group 3里面新增一个logfile member 大小与redo03.log相等

删除logfile

alter database drop logfile group 3; (删组)

alter database drop logfile member '/u01/oradata/wilson/redo03a.log';(删member)

仅删除控制文件里的信息，可在OS上将其rm掉

改变redolog 位置及名字

shutdown immediate

cd /u01/oradata/wilson

cp redo03.log ..(上一级)(也可是其它位置)

mv redo03.log redo03.rdo (改名)

startup mount

alter database rename file

'/u01/oradata/wilson/redo03.log' to '/u01/oradata/redo03.rdo';

alter database open

!

rm /u01/oradata/wilson/redo03.log

清空logfile  alter database clear logfile group 3;有可能损坏数据库，慎用!