在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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8119050/viewspace-1007195/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8119050/viewspace-1007195/