ORA-01184: logfile group 5 already exists

##########################
## Error
##########################

ORA-01184: logfile group 5 already exists

### Full Error

SQL> Alter database add logfile
  2  group 5 ('+RECO1/','+RECO2/','+RECO3/','+RECO4/') size 4096m;
Alter database add logfile
*
ERROR at line 1:
ORA-01184: logfile group 5 already exists

##########################
#  Error Occurred
##########################

Error occured while trying to add new redo log group in 11.2.0.3.0 version

##########################
## Command Executed
##########################

Alter database add logfile group 5 ('+RECO1/','+RECO2/','+RECO3/','+RECO4/') size 4096m;

**************************************** Step By Step Analysis ******************************************************

#########################################
# 1) Check Online Redo Log Available
#########################################

SQL> select group# from v$log;
    GROUP#
----------
        1
        2
        3
        4

Here we can see only 4 online redo log groups..

=====================================================================================================================

#########################################
# 2) Check Standby Redo Logs
#########################################

SQL> select group# from v$standby_log;
    GROUP#
----------
         5
         6
         7
         8
         9

=====================================================================================================================

##########################
## Solution
##########################

#### From step 2) we can see that standby redo logs are created with group 5

#### Below command completed successfully

Alter database add logfile group 10 ('+RECO1/','+RECO2/','+RECO3/','+RECO4/') size 4096m;

=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================