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同行回答

desert_xudesert_xu数据库运维工程师杭州xxxx有限公司
问题解决通过分析与文档的解释,确定了问题所在,即netbackup中设置的client name与client端的hostname不相同,导致了恢复的时候,无法找到正确的途径,导致恢复失败。将netbackup服务器上的client name修改成netbackup客户端的hostname,重新运行sbttest sbt_tape,restore测试通过。...显示全部

问题解决

通过分析与文档的解释,确定了问题所在,即netbackup中设置的client name与client端的hostname不相同,导致了恢复的时候,无法找到正确的途径,导致恢复失败。

将netbackup服务器上的client name修改成netbackup客户端的hostname,重新运行sbttest sbt_tape,restore测试通过。

看看能否解决你的问题

http://blog.itpub.net/32980/viewspace-1034587/

收起
医药 · 2017-02-21
浏览11664
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-32...显示全部

试试这个
问题和你一样

问题描述:

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
浏览12114

    提问者

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

    相关问题

    相关资料

    相关文章

    问题状态

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