channel CH00: restoring control file
released channel: CH00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/21/2017 10:27:31
ORA-19870: error reading backup piece /cntrl_36931_1_936134229
ORA-19507: failed to retrieve sequential file, handle="/cntrl_36931_1_936134229", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file not found in NetBackup catalog
这是脚本
RMAN> RUN {
2> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
3> SEND 'NB_ORA_SERV=backupserver,NB_ORA_CLIENT=p550a_svc';
4> RESTORE CONTROLFILE FROM '/cntrl_36931_1_936134229';
5> RELEASE CHANNEL CH00;
6> }
问题解决
通过分析与文档的解释,确定了问题所在,即netbackup中设置的client name与client端的hostname不相同,导致了恢复的时候,无法找到正确的途径,导致恢复失败。
将netbackup服务器上的client name修改成netbackup客户端的hostname,重新运行sbttest sbt_tape,restore测试通过。
看看能否解决你的问题
http://blog.itpub.net/32980/viewspace-1034587/
试试这个
问题和你一样
问题描述:
RMAN> run {
2> allocate channel t1 type \'sbt_tape\';
3> send \'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=hz1\';
4> restore controlfile to \'/oracle11/oradata/control01.ctl\' from \'/c-3201563006-20141026-02\';
5> release channel t1 ;
6> }
allocated channel: t1
channel t1: SID=239 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010010501)
sent command to channel: t1
Starting restore at 29-OCT-14
channel t1: restoring control file
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/29/2014 01:51:31
ORA-19870: error while restoring backup piece /c-3201563006-20141026-02
ORA-19507: failed to retrieve sequential file, handle=\"/c-3201563006-20141026-02\", parms=\"\"
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file not found in NetBackup catalog
解决方法:
异机环境的 oracle 软件属组,用户是否与源环境一致?
这里的一致包括user id ,group id 也是要一样的
NBU 自带的备份集权限参数:
bkup_image_perm =[user | group | any]
uset=>600
group =》640
any=》660
收起