在ORACLE中对在线重做日志文件进行调整

1.增加在线归档日志

alter database add logfile group 4 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo04.log') size 50M;
alter database add logfile group 5 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo05.log',

'/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo05.log') size 50M;

alter database add logfile member '/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo042.log' to group 4;

2.检查在线重做日志文件状态

select * from v$log;

3.转换在线重做日志文件

alter system switch logfile;
alter system switch logfile;

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

也可以删除其中一个成员:

alter database drop logfile member '/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo05.log';
4、操作系统下删除原日志组1、2、3中的文件
rm /home/oracle/oracle/product/10.2.0/oradata/gdimp/redo01.log
rm /home/oracle/oracle/product/10.2.0/oradata/gdimp/redo02.log
rm /home/oracle/oracle/product/10.2.0/oradata/gdimp/redo03.log

5、重建日志组1、2、3
alter database add logfile group 1 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo01.log') size 500M;
alter database add logfile group 2 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo02.log') size 500M;
alter database add logfile group 3 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo03.log') size 500M;

6、切换日志组
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

7、删除中间过渡用的日志组4、5
alter database drop logfile group 4;
alter database drop logfile group 5;

8、到操作系统下删除原日志组4、5中的文件
rm /home/oracle/oracle/product/10.2.0/oradata/gdimp/redo04.log
rm /home/oracle/oracle/product/10.2.0/oradata/gdimp/redo05.log

9、备份当前的最新的控制文件
SQL> connect internal
SQL> alter database backup controlfile to trace;