解决方案：调整redo logfile大小.
SQL> r
1* selectb.thread#,a.group#,a.member,bytes/1024/1024,b.members from v$logfile a,v$log bwhere a.group#=b.group#
THREAD# GROUP# MEMBER BYTES/1024/1024 MEMBERS
-------------------- ---------------------------------------- --------------- ----------
1 3/u01/app/oracle/oradata/EMREP/redo03.log 200 1
1 2/u01/app/oracle/oradata/EMREP/redo02.log 200 1
1 1/u01/app/oracle/oradata/EMREP/redo01.log 200 1
将redo大小调整到500m.
SQL>alter database add logfile group 4 ('/u01/app/oracle/oradata/EMREP/redo04.log')size 500m;
Databasealtered.
SQL>alter system switch logfile;
Systemaltered.
SQL>alter system checkpoint;
Systemaltered.
SQL>select group#,thread#,sequence#,members,status,archived from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS ARC
-------------------- ---------- ---------- ---------------- ---
1 1 13 1 INACTIVE NO
2 1 14 1 INACTIVE NO
3 1 12 1 INACTIVE NO
4 1 15 1 CURRENT NO
SQL>alter database drop logfile group 1; (说明：drop前需确认状态为INACTIVE)
Databasealtered.
SQL>select group#,thread#,sequence#,members,status,archived from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS ARC
-------------------- ---------- ---------- ---------------- ---
2 1 14 1 INACTIVE NO
3 1 12 1 INACTIVE NO
4 1 15 1 CURRENT NO
[oracle@leoEMREP]$ rm -rf redo01.log
SQL>alter database add logfile group 1 ('/u01/app/oracle/oradata/EMREP/redo01.log')size 500m;
Databasealtered.
SQL>select group#,thread#,sequence#,members,status,archived from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS ARC
-------------------- ---------- ---------- ---------------- ---
1 1 0 1 UNUSED YES
2 1 14 1 INACTIVE NO
3 1 12 1 INACTIVE NO
4 1 15 1 CURRENT NO
SQL>alter database drop logfile group 2;
Databasealtered.
SQL>alter database drop logfile group 3;
Databasealtered.
[oracle@leoEMREP]$ rm -rf redo02.log
[oracle@leoEMREP]$ rm -rf redo03.log
SQL>alter database add logfile group 2 ('/u01/app/oracle/oradata/EMREP/redo02.log')size 500m;
Databasealtered.
SQL>alter database add logfile group 3 ('/u01/app/oracle/oradata/EMREP/redo03.log')size 500m;
Databasealtered.
SQL>select group#,thread#,sequence#,members,status,archived from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS ARC
-------------------- ---------- ---------- ---------------- ---
1 1 0 1 UNUSED YES
2 1 0 1 UNUSED YES
3 1 0 1 UNUSED YES
4 1 15 1 CURRENT NO
SQL>alter system switch logfile;
Systemaltered.
SQL>alter system checkpoint;
Systemaltered.
SQL>select group#,thread#,sequence#,members,status,archived from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS ARC
-------------------- ---------- ---------- ---------------- ---
1 1 16 1 CURRENT NO
2 1 0 1 UNUSED YES
3 1 0 1 UNUSED YES
4 1 15 1 INACTIVE NO
SQL>alter database drop logfile group 4;
Databasealtered.
[oracle@leoEMREP]$ rm -rf redo04.log
SQL>select group#,thread#,sequence#,members,status,archived from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS ARC
-------------------- ---------- ---------- ---------------- ---
1 1 16 1 INACTIVE NO
2 1 17 1 CURRENT NO
3 1 0 1 UNUSED YES
SQL>select b.thread#,a.group#,a.member,bytes/1024/1024,b.members from v$logfilea,v$log b where a.group#=b.group#;
THREAD# GROUP# MEMBER BYTES/1024/1024 MEMBERS
-------------------- ---------------------------------------- --------------- ----------
1 2/u01/app/oracle/oradata/EMREP/redo02.log 500 1
1 3/u01/app/oracle/oradata/EMREP/redo03.log 500 1
1 1/u01/app/oracle/oradata/EMREP/redo01.log 500 1
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |