重庆思庄Oracle、Redhat认证学习论坛»首页 › 数据库 › Oracle › 安装EM13C时告警redo log file size should be 30000000 ...

最新公告：

帐号无法登录解决办法，必看!（2023-04-14）

返回列表

查看: 1322|回复: 0

[Oracle] 安装EM13C时告警redo log file size should be 300000000 bytes.

[复制链接]

denglj

denglj 当前离线

积分: 1503

电梯直达

楼主

发表于 2022-8-17 11:23:12 | 只看该作者回帖奖励

|倒序浏览 |阅读模式

问题描述：安装EM13C时告警redolog file size should be 300000000 bytes.

2202362fc5ee5b2f45.png (168.11 KB, 下载次数: 296)

下载附件

2022-8-17 11:22 上传

解决方案：调整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

分享到: QQ好友和群 QQ空间 腾讯微博 腾讯朋友

收藏0 支持0 反对0

使用道具举报

返回列表

高级模式

B Color Image Link Quote Code Smilies

您需要登录后才可以回帖登录 | 注册

本版积分规则回帖后跳转到最后一页

帐号		自动登录	找回密码
密码			注册