ORA-00261: log 12 of thread 1 is being archived or modified

                         drop standby logfile group reporting ORA-00261 and ORA-00312


------------------------------------------------------------------------------------------------------------

SQL>  alter database drop standby logfile group 12;
 alter database drop standby logfile group 12
*
ERROR at line 1:
ORA-00261: log 12 of thread 1 is being archived or modified
ORA-00312: online log 12 thread 1:
'/ora01_data1/STDBY1P/flash/STDBY1PP/onlinelog/o1_mf_12_bohc1hts_.log'

Solution

SQL> alter database clear logfile group 12;

Database altered.

SQL>  alter database drop standby logfile group 12;

Database altered.

SQL>  alter database add standby logfile  group 12 '/ora04_STDBY1P/data1/redo/STDBY_redoG12M1.rdo';

Database altered.


9 comments: