legato ORA-19870 ORA-19507 ORA-27029 ORA-19511

zhouwf0726發表於2019-04-12

Legato異機恢復oracle報錯，rman沒有任何錯誤日誌：
 ORA-19870: error reading backup piece full_open_IEBDPR01_h7k7ccrn_1575
 ORA-19507: failed to retrieve sequential file, handle="xxx", parms=""
 ORA-27029: skgfrtrv: sbtrestore returned error
 ORA-19511: Error received from media manager layer, error text:
 A backup or restore session is already in progress. (100:17:0)
 failover to previous backup

Server端remote access已經新增，測試客戶端不通：
 [root@bip-bdb02 ~]# nsrinfo -s xxx -n oracle yyy
 scanning client `yyy' for all savetimes from the oracle namespace on server xxx
 9714:nsrinfo: cannot start session with server xxx
 39078:nsrinfo: File index error: permission denied, `root' on `zzz' must have the 'Operate NetWorker' privilege OR the 'Recover Local Data' privilege for the client 'zzz'

查詢資料如下：
 The user must have the privileges:
        Monitor NetWorker
        Backup Local Data
        Recover Local Data
 
 In you case, you must also grant him:
        Configure NetWorker
        Operate NetWorker
 
 As the deletion is a a configuration issue, this will of course also be possible.
 Do not forget to monitor changes to the configuration (NW server - Monitor RAP option).
 
 On the other hand, you could also advise him to run the same group from the
 command line, just for a specific client:
        savegrp [-l level] -C client -G group
 In this case, there is no need for a re-configuration ;-).
 
 +----------------------------------------------------------------------
 |This was sent by carsten_reinfeld AT avus-cr DOT de via Backup Central.
 |Forward SPAM to abuse AT backupcentral DOT com.
 +----------------------------------------------------------------------

在legato server端新增相應的許可權，問題解決：
 [oracle@bip-bdb02 ~]$ nsrinfo -s xxx -n oracle yyy
 scanning client `OG2222-DBS301' for all savetimes from the oracle namespace on server xxx
 c-3169346478-20120511-02, date=1336715768 Fri 11 May 2012 01:56:08 PM CST
 cananf78_1_1, date=1336715752 Fri 11 May 2012 01:55:52 PM CST
 c-3169346478-20120511-01, date=1336714214 Fri 11 May 2012 01:30:14 PM CST
 c8nandml_1_1, date=1336714198 Fri 11 May 2012 01:29:58 PM CST
 c-3169346478-20120511-00, date=1336714055 Fri 11 May 2012 01:27:35 PM CST
 c6nandhc_1_1, date=1336714028 Fri 11 May 2012 01:27:08 PM CST
 6 objects found

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/756652/viewspace-723356/，如需轉載，請註明出處，否則將追究法律責任。

相關文章