RMAN备份 ORA-27086 RMAN-03009 ORA-01580报错处理

数据库版本

 

Oracle 10.2.0.4

 

 

问题描述

 

RMAN备份显示失败，查看日志，发现数据文件已经备份，但是在备份控制文件的时候报错

 

channel ch2: backup set complete, elapsed time: 00:32:56

Finished backup at 13-MAY-13

 

Starting Control File and SPFILE Autobackup at 13-MAY-13

released channel: ch1

released channel: ch2

released channel: ch3

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of Control File and SPFILE Autobackup command on ch1 channel at 05/13/2013 15:00:56

ORA-01580: error creating control backup file /nfsbackup/o16710g/rman/snapcf_o16710g_20130513_%F

ORA-27086: unable to lock file - already in use

Linux-x86_64 Error: 37: No locks available

Additional information: 10

 

RMAN>

 

 

处理过程

 

网上找到类以案例为nfslock进程存在问题，重启这个进程后问题解决

 

 

[root@svr28-167 ~]# service nfslock status

rpc.statd dead but pid file exists

[root@svr28-167 ~]#

 [root@svr28-167 ~]# service nfslock stop

Stopping NFS locking: [  OK  ]

Stopping NFS statd: [FAILED]

[root@svr28-167 ~]# service nfslock start

Starting NFS statd: [  OK  ]

[root@svr28-167 ~]#

[root@svr28-167 ~]# service nfslock status

rpc.statd (pid 25513) is running...

[root@svr28-167 ~]#

 

把这个服务添加到自启动中

[root@svr28-167 ~]#chkconfig nfslock on

[root@svr28-167 ~]#chkconfig --list|grep nfslock

nfslock         0:off   1:off   2:on    3:on    4:on    5:on    6:off

[root@svr28-167 ~]#

 

 

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

转载于:http://blog.itpub.net/21605631/viewspace-760960/