Database Backup and Recovery (MOSC)

MOSC Banner

How to kill "controlfile autobackup" operation that is causing ORA-00230

edited Apr 12, 2019 5:27AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Hello,

The database and O.S. configuration is:

Oracle 11.2.0.4 2-node RAC on Red Hat Enterprise Linux Server release 5.11

RMAN backup fails with the following:

Starting Control File and SPFILE Autobackup at 13-MAR-19RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 03/14/2019 00:11:15ORA-00230: operation disallowed: snapshot control file enqueue unavailable

I followed the MOS document:

RMAN: Backup Fails with ORA-230 Snapshot Controlfile Enqueue Unavailable (Doc ID 145619.1)

Performed the following (modified) SQL for RAC:

SELECT s.inst_id, s.sid, username AS "User", program, module, action, logon_time "Logon", l.*  FROM gv$session s, gv$enqueue_lock lWHERE s.inst_id=l.inst_id and l.sid = s.sid and l.type = 'CF' AND l.id1 = 0 and l.id2 = 2;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center