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