假设现有三个日志组,每个组内有一个成员,每个成员的大小为50MB,
现在想把此三个日志组的成员大小都改为500MB
0、查看原日志文件所在的目录
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/db/oracle10g/oradata/benguo/redo01.dbf
/db/oracle10g/oradata/benguo/redo02.dbf
/db/oracle10g/oradata/benguo/redo03.dbf
1、创建2个新的日志组
alter database add logfile group 4 ('
/db/oracle10g/oradata/benguo/redo04.dbf') size 50M;
alter database add logfile group 5 ('
/db/oracle10g/oradata/benguo/redo05.dbf') size 50M;
2、切换当前日志到新的日志组
alter system switch logfile;
alter system switch logfile;
(
切换到使 组4 或 组5 为CURRENT 状态
查看每组状态的命令为:
select group#,sequence#,archived,members,status from v$log;
使用如下命令使其他非当前组为不活跃状态
alter system checkpoint;
再次查询每组的状态,确认信息
SQL> select GROUP#,ARCHIVED,STATUS from v$log;
GROUP# ARC STATUS
---------- --- ----------------
1 NO INACTIVE
2 NO INACTIVE
3 NO INACTIVE
4 NO CURRENT
5 NO INACTIVE
)
3、删除旧的日志组
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
4、操作系统下删除原日志组1、2、3中的文件
host rm -rf /db/oracle10g/oradata/benguo/redo01.dbf
host rm -rf /db/oracle10g/oradata/benguo/redo02.dbf
host rm -rf /db/oracle10g/oradata/benguo/redo03.dbf
5、重建日志组1、2、3
alter database add logfile group 1 ('/db/oracle10g/oradata/benguo/redo01.dbf') size 500M;
alter database add logfile group 2 ('/db/oracle10g/oradata/benguo/redo02.dbf') size 500M;
alter database add logfile group 3 ('/db/oracle10g/oradata/benguo/redo03.dbf') size 500M;
6、切换日志组
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
(
切换到使 组1 或 组2 或 组3 为CURRENT 状态
查看每组状态的命令为:
select group#,sequence#,archived,members,status from v$log;
使用如下命令使其他非当前组为不活跃状态
alter system checkpoint;
再次查询每组的状态,确认信息
SQL> select GROUP#,ARCHIVED,STATUS from v$log;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 NO INACTIVE
3 NO INACTIVE
4 NO INACTIVE
5 NO INACTIVE
)
7、删除中间过渡用的日志组4、5
alter database drop logfile group 4;
alter database drop logfile group 5;
8、到操作系统下删除原日志组4、5中的文件
host rm -rf /db/oracle10g/oradata/benguo/redo04.dbf
host rm -rf /db/oracle10g/oradata/benguo/redo05.dbf
9、备份当前的最新的控制文件
SQL> connect internal
SQL> alter database backup controlfile to trace resetlogs
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/607244/viewspace-765481/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/607244/viewspace-765481/