case 1
alter
database add logfile group 6
(
'/san/redo1/HBLDS/redo06a.log',
'/san/redo2/HBLDS/redo06b.log'
)
size
20m
Thu
Apr 3 14:42:50 2008
ORA-1185
signalled during: alter database add logfile group 6
(
'/san/redo1/...
Case
(1)
ACTION
HBL>SELECT
TYPE,RECORDS_TOTAL FROM V$CONTROLFILE_RECORD_SECTION;
TYPE RECORDS_TOTAL
--------------------
-------------
DATABASE 1
CKPT
PROGRESS 4
REDO
THREAD 1
REDO
LOG 5
DATAFILE 100
FILENAME 116
TABLESPACE 100
TEMPORARY
FILENAME 100
RMAN
CONFIGURATION 50
LOG
HISTORY 908
OFFLINE
RANGE 292
TYPE RECORDS_TOTAL
--------------------
-------------
ARCHIVED
LOG 840
BACKUP
SET 409
BACKUP
PIECE 200
BACKUP
DATAFILE 564
BACKUP
REDOLOG 5812
DATAFILE
COPY 223
BACKUP
CORRUPTION 371
COPY
CORRUPTION 409
DELETED
OBJECT 818
PROXY
COPY 211
BACKUP
SPFILE 454
TYPE RECORDS_TOTAL
--------------------
-------------
DATABASE
INCARNATION 292
23
rows selected.
In
the above u can observe that REDO LOG 5 -- max that can be created
This
is why we are not able to create . To modify this we need to recreate the
controlfile.
case 2.
alter database add logfile group 2
(
' /san/redo1/HBLDS/redo02a.log',
' /san/redo2/HBLDS/redo02b.log'
)
size 20m;
ERROR at line 1:
ORA-00301: error in adding log file '
/san/redo1/HBLDS/redo02a.log' - file cannot be created
ORA-27040: skgfrcre: create error, unable to create file
Linux-ia64 Error: 2: No such file or directory
Case
(2)
ACTION
Plz
check there should not be any spaces in the filename patch. here there is a space before /san