oracle中的日志生成器,在ORACLE中对在线重做日志文件进行调整

在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;[@more@]