Netbackup For Oracle RMAN恢复出错

itpoper

环境为: NBU  Server :  NBU4.5 , AIX5.2
           NBU  Client  :  NBU4.5 ,AIX 5.2 ,Oracle 9.2

我建了两个RMAN备份的Policy，一个Policy做每周的Full database backup;一个Policy做每天的Archive log backup。（Scripts用NBU自带的sample修改的）
这两个Policy的备份都正常，返回值都为0。
但是在恢复是出现错误；
我的恢复一是用RMAN命令：
RMAN>;run{
2>; allocate channel ch00 type disk;
3>; restore
4>;      database;
5>; recover
6>;      database;
7>; release channel ch00;
8>; }
另是用NBU Client的jbpSA，但是都返回错误。

以下是用jbpSA执行时的log：
Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

2>;
3>; # -----------------------------------------------------------------
4>; # RMAN command section
5>; # -----------------------------------------------------------------
6>;
7>; RUN {
8>;
9>; ALLOCATE CHANNEL ch00
10>;     TYPE 'SBT_TAPE';
11>; SEND 'NB_ORA_CLIENT=p670a_svr';
12>;
13>; RESTORE
14>;     DATABASE
15>;     CHECK READONLY;
16>;
17>; RECOVER
18>;     DATABASE;
19>;
20>; RELEASE CHANNEL ch00;
21>; }
22>;
using target database controlfile instead of recovery catalog

allocated channel: ch00
channel ch00: sid=13 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)

sent command to channel: ch00

Starting restore at 16-APR-04

channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/hzsgs/system01.dbf
restoring datafile 00010 to /oradata/hzsgs/GSJ.dbf
restoring datafile 00016 to /oradata/hzsgs/expand/GONGSU.dbf
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/16/2004 15:43:46
ORA-19507: failed to retrieve sequential file, handle="bk_47_1_523634981", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   sbtrestore: Failed to open for restore.

Recovery Manager complete.


那位熟悉NBU的大虾一起分析分析，Thank you

itpoper

刚才的RMAN命令写错了，为
RMAN>;run{
2>; allocate channel ch00 type 'sbt_tape';
3>; restore
4>; database;
5>; recover
6>; database;
7>; release channel ch00;

aixdb2

NetBackup的active monitor有错吗?

aixdb2

在客户端用bplist -t 4 -R /确认NetBackup有备份oracle,用rman 里的list backup看rman看到几号的备份

aixdb2

可能过期了

aixdb2

在/usr/openv/netbackup/logs下建bphdb和dbclient,加VERBOSE到bp.conf,再恢复一次看日志

itpoper

好的,谢谢,下周到客户哪里再试试