在线扩大redo日志大小

#查看日志组状态
SQL> select group#,members,bytes/1024/1024,status from v$log;
#查看当前日志组成员
SQL> select member from v$logfile;
#创建2个新的过渡日志组
SQL> alter database add logfile group 4(‘/data/u01/app/oracle/oradata/orcly/redo04.log’) size 500M;
SQL> alter database add logfile group 5(‘/data/u01/app/oracle/oradata/orcly/redo05.log’) size 500M;
#切换日志并做检查点，确定123组日志处于inactive状态
SQL> alter system switch logfile;
SQL> alter system checkpoint;
SQL> select group#,members,bytes/1024/1024,status from v$log;

GROUP# MEMBERS BYTES/1024/1024 STATUS
———- ———- ————— —————-
1 1 50 INACTIVE
2 1 50 INACTIVE
3 1 50 INACTIVE
4 1 500 ACTIVE
5 1 500 CURRENT
#数据库删除123组日志
SQL> alter database drop logfile group 1
SQL> alter database drop logfile group 2
SQL> alter database drop logfile group 3
#OS删除文件
$rm redo01.log redo02.log redo03.log
#数据库添加123组日志
SQL> alter database add logfile group 1(‘/data/u01/app/oracle/oradata/orcly/redo01.log’) size 2048M;
SQL> alter database add logfile group 2(‘/data/u01/app/oracle/oradata/orcly/redo02.log’) size 2048M;
SQL> alter database add logfile group 3(‘/data/u01/app/oracle/oradata/orcly/redo03.log’) size 2048M;

同上删除4、5组日志即可

未经允许不得转载：SRE空间 » 在线扩大redo日志大小