oracle redo log file文件详解
alter database add logfile group 3 ('$HOME/Oradata/u01/log3a.rdo','$HOME/Oradata/u02/log3b.rdo')
复制代码
（2）.对某个Group增加Redo Log File文件：
alter database add logfile member
'$HOME/Oradata/u04/log1c.rdo' to group 1,
'$HOME/Oradata/u04/log2c.rdo' to group 2,
'$HOME/Oradata/u04/log3c.rdo' to group 3,
复制代码
（3）.删除Redo Log File Member(每个Redo Log File Group中的每个Log文件都称为一个Member)
alter database drop logfile member
'$HOME/Oradata/u04/log3c.rdo';
复制代码
（4）.删除Redo Log File Group
alter database drop logfile group 2;
5.Redo Log File建议用“.rdo”结尾。
6.可通过动态性能视图（Dynamic Performance View）查询Redo Log File的相关信息。
（1）.v$log：Display the redo log fileinformation from the control file.
页:
[1]