Skip to Content
0
Former Member
Nov 29, 2011 at 07:31 AM

increse of redo log size

531 Views

Hi,

Please help me to increase the redo log size.

As i am in DB - oracle 10G and OS - Suse linux 10SP2

SQL> SELECT * FROM v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-


-


-


-


-


--- -


FIRST_CHANGE# FIRST_TIME

-


-


1 1 358 157286400 2 YES INACTIVE

2972903289 28-NOV-11

2 1 359 157286400 2 YES INACTIVE

2972957401 28-NOV-11

3 1 357 157286400 2 YES INACTIVE

2972839164 27-NOV-11

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-


-


-


-


-


--- -


FIRST_CHANGE# FIRST_TIME

-


-


4 1 360 157286400 2 NO CURRENT

2973005629 29-NOV-11

SQL> SELECT * FROM v$logfile;

GROUP# STATUS TYPE

-


-


-


MEMBER

-


IS_

---

4 ONLINE

/oracle/JID/origlogB/log_g14m1.dbf

NO

4 ONLINE

/oracle/JID/mirrlogB/log_g14m2.dbf

NO

GROUP# STATUS TYPE

-


-


-


MEMBER

-


IS_

---

3 ONLINE

/oracle/JID/origlogA/log_g13m1.dbf

NO

3 ONLINE

/oracle/JID/mirrlogA/log_g13m2.dbf

GROUP# STATUS TYPE

-


-


-


MEMBER

-


IS_

---

NO

2 ONLINE

/oracle/JID/origlogB/log_g12m1.dbf

NO

2 ONLINE

GROUP# STATUS TYPE

-


-


-


MEMBER

-


IS_

---

/oracle/JID/mirrlogB/log_g12m2.dbf

NO

1 ONLINE

/oracle/JID/origlogA/log_g11m1.dbf

NO

GROUP# STATUS TYPE

-


-


-


MEMBER

-


IS_

---

1 ONLINE

/oracle/JID/mirrlogA/log_g11m2.dbf

NO

8 rows selected.

Please help me how to execute for the above query.

Thanks,

Hariharan