NBU7.1+RMAN异机恢复报错

lzxin

已设置 /usr/openv/netbackup/db/altnames/No.Restrictions

RMAN> alter database mount;

database mounted

RMAN> run{
2>   ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3>   send 'NB_ORA_SERV=nbusvr,NB_ORA_CLIENT=oratest';
4>   restore database;
5>   recover database;
6>   RELEASE CHANNEL ch00;
7>   }

allocated channel: ch00
channel ch00: sid=156 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011082514)

sent command to channel: ch00

Starting restore at 01-DEC-11

channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /bank/oradata/imbs/undotbs01.dbf
restoring datafile 00012 to /bank/oradata/ts_base_imbs02.dbf
restoring datafile 00013 to /bank/oradata/ts_app_imbs01.dbf
restoring datafile 00014 to /bank/oradata/ts_app_imbs02.dbf
channel ch00: reading from backup piece bk_137_1_768441161
ORA-19870: error reading backup piece bk_137_1_768441161
ORA-19507: failed to retrieve sequential file, handle="bk_137_1_768441161", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_137_1_768441161> not found in NetBackup catalog
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /bank/oradata/imbs/system01.dbf
restoring datafile 00004 to /bank/oradata/imbs/users01.dbf
restoring datafile 00005 to /bank/oradata/ts_ind_imbs01.dbf
restoring datafile 00009 to /bank/oradata/ts_tabhis_imbs01.dbf
restoring datafile 00011 to /bank/oradata/ts_base_imbs01.dbf
channel ch00: reading from backup piece bk_138_1_768441161
ORA-19870: error reading backup piece bk_138_1_768441161
ORA-19507: failed to retrieve sequential file, handle="bk_138_1_768441161", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_138_1_768441161> not found in NetBackup catalog

C字裤男爵

oracle$/usr/openv/netbackup/bin/bplist -C oratest -t 4 -R -l / |grep bk_138_1_768441161
看看有无输出？

你oracle原主机主机名是？
测试机主机名是？
原oracle是备份到master还是media？
你测试机bp.conf有没有media server行？

lzxin

回复 2# C字裤男爵


    $/usr/openv/netbackup/bin/bplist -C imdbdb-t 4 -R -l / |grep bk_138_1_768441161
    是有的

    原主机主机名:imdbdb
    测试主机名ratest:
    备份放到media server上的，也有直接到带库上的
   测试机没有写media server

无牙

1. 'NB_ORA_SERV=nbusvr,NB_ORA_CLIENT=oratest';
这个地方不对，要写原Oralce数据库的client name

2. 需要添加这个参数在master server bp.conf
FORCE_RESTORE_MEDIA_SERVER = imdbdb nbusvr

lzxin

搞定,斑竹无敌