1.新增两个日志组
alter database add logfile group 4('D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 200M;
alter database add logfile group 5('D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOG') size 200M;
2.切换日志组
alter system switch logfile;
alter system switch logfile;
3.直到之前的三个日志组状态都变为 Inactive,删除,否则会报错
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
CURRENT
指当前的日志文件,在进行实例恢复时是必须的;ACTIVE
是指活动的非当前日志,在进行实例恢复时会被用到。Active
状态意味着,Checkpoint
尚未完成,因此该日志文件不能被覆盖。INACTIVE
是非活动日志,在实例恢复时不再需要,但在介质恢复时可能需要。UNUSED
表示该日志从未被写入,可能是刚添加的,或RESETLOGS
后被重置。
4.删除操作系统上的3个日志文件
5.添加原来的三个日志文件组
alter database add logfile group 1('D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG') size 200M;
alter database add logfile group 2('D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG') size 200M;
alter database add logfile group 3('D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG') size 200M;
6.切换日志组
alter system switch logfile;
alter system switch logfile;alter system switch logfile;
7. 老样子直到之前的2个日志组状态都变为 Inactive,删除,否则会报错
alter database drop logfile group 4;
alter database drop logfile group 5;