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有限公司

试试这个
问题和你一样

问题描述:

RMAN>  run {
2>  allocate channel t1 type \'sbt_tape\';
3>  send \'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=hz1\';
4>  restore controlfile to \'/oracle11/oradata/control01.ctl\' from \'/c-3201563006-20141026-02\';
5>  release channel t1 ;
6>  }

allocated channel: t1
channel t1: SID=239 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010010501)

sent command to channel: t1

Starting restore at 29-OCT-14

channel t1: restoring control file
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/29/2014 01:51:31
ORA-19870: error while restoring backup piece /c-3201563006-20141026-02
ORA-19507: failed to retrieve sequential file, handle=\"/c-3201563006-20141026-02\", parms=\"\"
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file not found in NetBackup catalog

解决方法:

异机环境的 oracle 软件属组,用户是否与源环境一致?

这里的一致包括user id ,group id  也是要一样的

NBU 自带的备份集权限参数:

bkup_image_perm =[user | group | any]

uset=>600

group =》640

any=》660

医药 · 2017-02-21
浏览12110

回答者

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

desert_xu 最近回答过的问题

回答状态

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