Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

increasing archivelog file size

John-MKJul 30 2013 — edited Jul 30 2013

Hi,

11.2.0.2 on RHL..

3 Log Groups with 1 member each.

db_recovery_file_dest

string

/oracle/oraarch

For the purpose of increasing log file size, if i use ALTER DATABASE ADD LOGFILE GROUP 1 SIZE 300M; but it creates Log Group with 2 member. one is at /oracle/oraarch location and other at /oracle/oradata (db_create_file_dest). We are using ORACLE MANAGED FILE SYSEM .

I want only 1 member at /oracle/oraarch (to keep the previous setting intact ...just increasing the size from 100 to 300M).

If I manually give the path where to create the logfile member, I get this error:

ALTER DATABASE ADD LOGFILE GROUP 1 '/oracle/oraarch/DB/onlinelog/' SIZE 300M;

ALTER DATABASE ADD LOGFILE GROUP 1 '/oracle/oraarch/DB/onlinelog/' SIZE 300M

ERROR at line 1:

ORA-00301: error in adding log file '/oracle/oraarch/DB/onlinelog/' - file cannot be created

ORA-27038: created file already exists

Additional information: 1

Please suggest.

Thanks a lot.

Best Regards

This post has been answered by John-MK on Jul 30 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2013

Added on Jul 30 2013

#general-database-discussions

8 comments

3,501 views