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