NBU中恢复数据库 报一下错误,请大家帮忙看看啥原因

channel CH00: restoring control filereleased channel: CH00RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ======================================...显示全部

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> }

收起
参与49

查看其它 10 个回答desert_xu的回答

desert_xudesert_xu数据库运维工程师杭州xxxx有限公司

问题解决

通过分析与文档的解释,确定了问题所在,即netbackup中设置的client name与client端的hostname不相同,导致了恢复的时候,无法找到正确的途径,导致恢复失败。

将netbackup服务器上的client name修改成netbackup客户端的hostname,重新运行sbttest sbt_tape,restore测试通过。

看看能否解决你的问题

http://blog.itpub.net/32980/viewspace-1034587/

医药 · 2017-02-21
浏览11645

回答者

desert_xu
数据库运维工程师杭州xxxx有限公司
擅长领域: 数据库服务器前置系统

desert_xu 最近回答过的问题

回答状态

  • 发布时间:2017-02-21
  • 关注会员:6 人
  • 回答浏览:11645
  • X社区推广