Re: ORA-00230 during RMAN backup
- From: fmhabash <fmhabash@xxxxxxxxx>
- To: Ian.Cary@xxxxxxxxxxxxxx
- Date: Wed, 26 Sep 2007 10:44:18 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
