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 个回答yangsuhua的回答

yangsuhuayangsuhua存储架构师浪潮信息

restore from 的语法跟的控制文件名字,需要和备份软件的db里面记录的名称一致。不一致,或者该文件已被清理,就会报找不到这个文件。如果你有control file autobackup也可以从autobackup恢复。找到备份软件端检查一下文件是否是可恢复状态及文件名是否正确吧。

硬件生产 · 2017-02-21
浏览11807

回答者

yangsuhua
存储架构师浪潮信息
擅长领域: 存储服务器备份

yangsuhua 最近回答过的问题

回答状态

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