Can not add a new member to the existing log group.
680524Dec 27 2010 — edited Dec 28 2010Dear all,
I just want to multiplex the online redo log to different devices for security reason. I just have one member for each group. So I want to use this command to add a new member.
alter database add logfile member '/u02/oracle/oradata/TEST/redo01.log' to ('/u01/app/oracle/oradata/TEST/redo01.log')
or
alter database add logfile member '/u02/oracle/oradata/TEST/redo01.log' to group 1.
But both commands failed with error pasted below:
*
ERROR at line 1:
ORA-19510: failed to set size of 102400 blocks for file "/u02/oracle/oradata/TEST/redo01.log" (block size=512)
ORA-27045: unable to close the file
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Do you know what caused this problem?
Thanks,
Ricky