问题描述：安装EM13C时告警redo log file size should be 300,000,000bytes.
解决方案：调整redo log file大小.
SQL> r
1* select
b.thread#,a.group#,a.member,bytes/1024/1024,b.members from v$logfile a,v$log b
where 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;
Database
altered.
SQL>
alter system switch logfile;
System
altered.
SQL>
alter system checkpoint;
System
altered.
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)
Database
altered.
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@leo
EMREP]$ rm -rf redo01.log
SQL>
alter database add logfile group 1 ('/u01/app/oracle/oradata/EMREP/redo01.log')
size 500m;
Database
altered.
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;
Database
altered.
SQL>
alter database drop logfile group 3;
Database
altered.
[oracle@leo
EMREP]$ rm -rf redo02.log
[oracle@leo
EMREP]$ rm -rf redo03.log
SQL>
alter database add logfile group 2 ('/u01/app/oracle/oradata/EMREP/redo02.log')
size 500m;
Database
altered.
SQL>
alter database add logfile group 3 ('/u01/app/oracle/oradata/EMREP/redo03.log')
size 500m;
Database
altered.
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;
System
altered.
SQL>
alter system checkpoint;
System
altered.
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;
Database
altered.
[oracle@leo
EMREP]$ 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$logfile
a,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
