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

zhenyu6688zhenyu6688运维工程师中亦安图

首先请查一下sbttest命令是否已经通过。

其次list backup查一下这个control file是否存在,再一个我觉得那个恢复controlfile的时候,应该是不需要加斜线的。直接

restore controlfile from \'cntrl_36931_1_936134229\';试试呢。

系统集成 · 2017-02-21
浏览11624

回答者

zhenyu6688
运维工程师中亦安图
擅长领域: 备份存储软件定义存储

zhenyu6688 最近回答过的问题

回答状态

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