Hi
I'm working on this issue.
A member of an logfile group has been deleteted on OS level.
To fix this, I would like to recreate it.
Therefore I issued:
ALTER DATABASE DROP LOGFILE MEMBER '/opt/oracle/orafra2/PRODSHOP/onlinelog/o1_mf_3_cq2llff2_.log';
Afterwards:
alter database add logfile member '/opt/oracle/orafra2' to group 3;
I run into:
ERROR at line 1:
ORA-00301: error in adding log file '/opt/oracle/orafra2' - file cannot be
created
ORA-27038: created file already exists
Additional information: 1
Of course, I could create a complete ne group as work a round.
| db_create_online_log_dest_1 | string | /opt/oracle/oradata2 |
| db_create_online_log_dest_2 | string | /opt/oracle/orafra2 |