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

chenqiang2942chenqiang2942系统工程师软通动力

在p550a上查下磁带上的控制文件:

p550a:/#/usr/openv/netbackup/bin/bplist -C  p550a_svc -t 4 -l -R /

-rw-rw---- orahle    dba          20185088 Feb 20 21:10 /cntrl_36969_1_936479441

-rw-rw---- orahle    dba         571998208 Feb 20 20:29 /al_36968_1_936476996

-rw-rw---- orahle    dba         589037568 Feb 20 20:27 /al_36967_1_936476857

-rw-rw---- orahle    dba          20185088 Feb 19 21:10 /cntrl_36966_1_936393016

-rw-rw---- orahle    dba         542900224 Feb 19 20:27 /al_36965_1_936390458

-rw-rw---- orahle    dba          20185088 Feb 18 21:10 /cntrl_36964_1_936306611

-rw-rw---- orahle    dba         661127168 Feb 18 20:27 /al_36963_1_936304059

-rw-rw---- orahle    dba          20185088 Feb 18 13:05 /cntrl_36962_1_936277499

-rw-rw---- orahle    dba         298319872 Feb 18 12:22 /al_36961_1_936274938

-rw-rw---- orahle    dba            262144 Feb 18 11:34 /bk_36960_1_936272072

-rw-rw---- orahle    dba          20185088 Feb 18 11:24 /bk_36959_1_936271466

-rw-rw---- orahle    dba          9792512K Feb 18 11:21 /bk_36958_1_936271271

-rw-rw---- orahle    dba          7339776K Feb 18 11:15 /bk_36957_1_936270905

-rw-rw---- orahle    dba          9878528K Feb 18 11:11 /bk_36956_1_936270700

-rw-rw---- orahle    dba         10124800K Feb 18 11:03 /bk_36955_1_936270224

-rw-rw---- orahle    dba         11178496K Feb 18 10:59 /bk_36954_1_936269979

-rw-rw---- orahle    dba         10857984K Feb 18 10:52 /bk_36953_1_936269523

-rw-rw---- orahle    dba         10888448K Feb 18 10:46 /bk_36952_1_936269178



这里都可以查到

但是在恢复机上恢复就报错

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_36969_1_936479441\';

5> RELEASE CHANNEL  CH00;

6> }

allocated channel: CH00

channel CH00: sid=303 devtype=SBT_TAPE

channel CH00: Veritas NetBackup for Oracle - Release 7.1 (2011020322)

sent command to channel: CH00

Starting restore at 21-FEB-17

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 15:58:34

ORA-19870: error reading backup piece /cntrl_36969_1_936479441

ORA-19507: failed to retrieve sequential file, handle=\"/cntrl_36969_1_936479441\", 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>

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

回答者

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

chenqiang2942 最近回答过的问题

回答状态

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