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

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

11同行回答

mmsc5166mmsc5166系统工程师某金融公司信息技术中心
ORA-19507: failed to retrieve sequential file, handle=\"/cntrl_36969_1_936479441\", parms=\"\"RESTORE CONTROLFILE FROM \'/cntrl_36969_1_936479441\';--你把cntrl_36969_1_936479441前面的 ‘/’ 去掉试试显示全部

ORA-19507: failed to retrieve sequential file, handle=\"/cntrl_36969_1_936479441\", parms=\"\"



RESTORE CONTROLFILE FROM \'/cntrl_36969_1_936479441\';

--你把cntrl_36969_1_936479441前面的 ‘/’ 去掉试试

收起
金融其它 · 2017-02-21
浏览11787
mmsc5166mmsc5166系统工程师某金融公司信息技术中心
先检查一下源库的controlfile的备份情况rman target /Rman>list backup of controlfile;--看看显示的是什么东东显示全部

先检查一下源库的controlfile的备份情况

rman target /

Rman>list backup of controlfile;--看看显示的是什么东东

收起
金融其它 · 2017-02-21
浏览6985

    提问者

    chenqiang2942
    系统工程师软通动力
    擅长领域: 灾备服务器系统管理

    相关问题

    相关资料

    相关文章

    问题状态

  • 发布时间:2017-02-21
  • 关注会员:6 人
  • 问题浏览:21846
  • 最近回答:2017-02-22
  • X社区推广