Re: ORA-00230 during RMAN backup

this is what I did when in encountered this issue a long time ago


Issue below query and grab sid and serial#.
select s.sid, username, program, module, action, logon_time, l.* from v$session s, v$enqueue_lock l where l.sid = s.sid and l.type = 'CF' and l.id1 = 0 and l.id2 = 2; 

From v$session, find PADDR value i.e. process address.

Match above PADDR with v$process ADDR and get SPID.

Use ps -ef to find SPID and kill it. (or wait for it to finish if you can)

Issue query in step 1 to make sure lock is gone

See here for more details Note:145619.1
--
http://www.freelists.org/webpage/oracle-l

Other related posts: