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/，如需轉載，請註明出處，否則將追究法律責任。