Today in this article, we will learn how to resolve ORA-00261 error. Let’s go through this :
Table of Contents
Error :
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 10;
ALTER DATABASE DROP STANDBY LOGFILE GROUP 10
*
ERROR at line 1:
ORA-00261: log 10 of thread 1 is being archived or modified
ORA-00312: online log 10 thread 1: '/u01/app/oracle/stby_redo1.log'
Solution :
First, we have to clear the standby log file.
SQL> alter database clear logfile group 10;
Now, we can drop the standby log file.
SQL> alter database drop standby logfile group 10;
If you want to add, you can recreate the standby log file as well :
SQL> alter database add standby logfile group 10 '/u01/app/oracle/stby_redo1.log';
Also, you can get more information from the below Oracle Doc as well :
ORA-00261 Occurred In Standby Alertlog (Doc ID 3012780.1)
Related Articles :
