Oracle Database 12.2.0
RHEL 7.4
Hello Team,
whenever I drop redo log groups(alter database drop logfile group 2), why are the redo logs not physically removed from disks?
SQL> alter database add logfile group 2 ('+FRA/DWARE1/ONLINELOG/redo2a.rdo','+REDO/DWARE1/ONLINELOG/redo2b.rdo') size 2097152000;
alter database add logfile group 2 ('+FRA/DWARE1/ONLINELOG/redo2a.rdo','+REDO/DWARE1/ONLINELOG/redo2b.rdo') size 2097152000
*
ERROR at line 1:
ORA-00301: error in adding log file '+FRA/DWARE1/ONLINELOG/redo2a.rdo' - file
cannot be created
ORA-17502: ksfdcre:4 Failed to create file +FRA/DWARE1/ONLINELOG/redo2a.rdo
ORA-15005: name "DWARE1/ONLINELOG/redo2a.rdo" is already used by an existing
alias
Regards,
Joe