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