Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2013
Added on Jul 30 2013
8 comments
3,210 views