ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oerr--解决在备份时出现的ORA-230

Oerr--解决在备份时出现的ORA-230

原创 Linux操作系统 作者:vongates 时间:2019-07-19 14:21:01 0 删除 编辑
今天在备份时再次遇到ORA-230,在不久前遇到过,当时还想着帖上解决过程的呢。今天遇到时,都有点不记得了。帖上过程方便以后需要时参考(相关信息来自metalink)

备份时的出错信息的片段如下:

validation succeeded for archived log
archive log filename=/oradata/IFXPROD/arch1/IFXPROD_1_2180.arc recid=4358 stamp=588573189
validation succeeded for archived log
archive log filename=/oradata/IFXPROD/arch1/IFXPROD_1_2181.arc recid=4360 stamp=588578555
Crosschecked 2 objects

Starting backup at 24-APR-06
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 04/24/2006 12:56:49
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

查看matalink后可以确认是因为有enquen lock存在,相关的SQL如下:

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

我是能过kill上面查得的SID后,再重做backup来解决的。更详细的内容可以查看下面的两个link(需要有metalink的帐号):

文档1

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51929/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    291754