ORA-01184: Logfile Already Exists

Buğra PARLAYAN

1 year ago

In today’s article, we will look at the cause of a possible error that we may receive if we want to add Redo Log on ASM.

For example, let’s add a Redo with the following command.

SQL> alter database add logfile thread 1 group 5 (‘+DATA′,’+FRA’) size 2048M;

1	SQL> alter database add logfile thread 1 group 5 (‘+DATA′,’+FRA’) size 2048M;

Under normal conditions, we should be able to add with this command, but we got an error and it says that a redon named “group 5” already exists.

ERROR at line 1:
ORA-01184: logfile group 5 already exists

1 2	ERROR at line 1: ORA-01184: logfile group 5 already exists

I’m checking it but I can’t see it.

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

SQL> select group# from v$log;

GROUP#

----------

This time I check my Standby Redo file and see it’s here.

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

select group# from v$standby_log;

GROUP#

----------

I refresh the command and create a Redo Log file.

SQL> alter database add logfile thread 1 group 10 (‘+DATA′,’+FRA’) size 2048M;

1	SQL> alter database add logfile thread 1 group 10 (‘+DATA′,’+FRA’) size 2048M;