Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can't drop redo log group on standby

Flabbergasted GeorgeJun 5 2017 — edited Jun 7 2017

I am getting ora-1623 when trying to drop a redo log group on a physical standby db(11.2.0.4). I've followed the instructions in Doc ID 740675.1 but even after clearing the logs it still doesn't allow the drop. One interesting note is that they are never in a clearing or current status, only status I see is unused. I was able to drop two other groups but this one won't budge and it never switches to the other groups.

SELECT * FROM V$LOG;

pastedImage_0.png

I've set standby_file_management to manual and turned off recovery in dgmgrl:

DGMGRL> edit database 'CMS_136' set property StandbyFileManagement=manual;

Property "standbyfilemanagement" updated

DGMGRL> edit database 'CMS_136' set state='APPLY-OFF';

Succeeded.

DGMGRL>

I'm able to clear logfile group:

SQL> alter database clear logfile group 3;

Database altered.

But error when I try to drop it:

SQL> ALTER DATABASE DROP LOGFILE GROUP 3;

ALTER DATABASE DROP LOGFILE GROUP 3

*

ERROR at line 1:

ORA-01623: log 3 is current log for instance cms (thread 1) - cannot drop

ORA-00312: online log 3 thread 1: 'F:\APP\ORACLE\ORADATA\CMS\REDO1\REDO03A.RDO'

ORA-00312: online log 3 thread 1: 'F:\APP\ORACLE\ORADATA\CMS\REDO2\REDO03B.RDO'

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2017
Added on Jun 5 2017
#data-guard, #performance-availability
15 comments
13,025 views