扩大redo log

----判断当前状态
select a.group#,b.member,a.status from v$log a,v$logfile b where a.group# = b.group#;

3 /home/oracle/oradata/new/redo03.log CURRENT
2 /home/oracle/oradata/new/redo02.log INACTIVE
1 /home/oracle/oradata/new/redo01.log INACTIVE

---- 删除原来旧的redo logfile. （inactive状态的）

alter database drop logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;

----- 往数据库添加三个大的redo logfile

ALTER DATABASE ADD LOGFILE GROUP 1 ('/home/oracle/oradata/ora10g/redo01.log') size 100M reuse;

ALTER DATABASE ADD LOGFILE GROUP 2 ('/home/oracle/oradata/ora10g/redo02.log') size 100M reuse;

ALTER DATABASE ADD LOGFILE GROUP 3 ('/home/oracle/oradata/ora10g/redo03.log') size 100M reuse;

----- 切换日志

alter system switch logfile;

此操作可以执行一到几次, 使旧的redo logfile成invalid状态.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/51862/viewspace-180575/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/51862/viewspace-180575/