oracle 重做日志文件

1、手工切换重做日志文件

         alter system switch logfile;

2、增加在线重做日志文件

ALTER DATABASE ADD LOGFILE GROUP 3 ('XXX/log3a.rdo','XXX/log3b.rdo') SIZE 10M;

3、增加组成员

ALTER DATABASE ADD LOGFILE MEMBER      'XXX/log1c.rdo' TO GROUP 1,  'XXX/log1c.rdo' TO GROUP 2, 'XXX/log1c.rdo' TO GROUP 3;

4、 删除重做日志组

alter database drop logfile group 3;

5、查询日志组及成员信息

      select  *  from   V$LOG

      select  *  fromV$LOGFILE