数据库版本
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/