1          概述

问题简述：netbackup rman restore archivelog 报ora-19511错误，导致恢复归档日志不成功。

操作系统：aix 5.3

数据库：oracle 9.2.0.6

2          问题描述

     p550a[oracle]$rman target / catalog rman_afis40/rman_afis40@rman

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

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

connected to target database: AFIS40 (DBID=830087130)

connected to recovery catalog database

RMAN>  run {

     a2> llocate channel t1 type 'SBT_TAPE'

     parms 'ENV=(NB_ORA_SERV=gzbackup,

                  NB_ORA_SCHED=Default-Application-Backup,

                  NB_ORA_CLASS=ora_arch_afis40,

                  NB_ORA_CLIENT=p550a)';

     restore archivelog from sequence 2342;

     release channel t1;

     }

     3> 4> 5> 6> 7> 8> 9>

allocated channel: t1

channel t1: sid=44 devtype=SBT_TAPE

channel t1: Veritas NetBackup for Oracle - Release 6.5 (2009050106)

Starting restore at 01-APR-10

archive log thread 1 sequence 2373 is already on disk as file /arch_dg/1_2373.dbf

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2342

channel t1: restoring archive log

archive log thread=1 sequence=2343

channel t1: restoring archive log

archive log thread=1 sequence=2344

channel t1: restoring archive log

archive log thread=1 sequence=2345

channel t1: restoring archive log

archive log thread=1 sequence=2346

channel t1: restoring archive log

archive log thread=1 sequence=2347

channel t1: restoring archive log

archive log thread=1 sequence=2348

channel t1: restoring archive log

archive log thread=1 sequence=2349

channel t1: restoring archive log

archive log thread=1 sequence=2350

channel t1: restoring archive log

archive log thread=1 sequence=2351

channel t1: restoring archive log

archive log thread=1 sequence=2352

channel t1: restoring archive log

archive log thread=1 sequence=2353

channel t1: restoring archive log

archive log thread=1 sequence=2354

channel t1: restoring archive log

archive log thread=1 sequence=2355

channel t1: restoring archive log

archive log thread=1 sequence=2356

channel t1: restoring archive log

archive log thread=1 sequence=2357

channel t1: restoring archive log

archive log thread=1 sequence=2358

channel t1: restoring archive log

archive log thread=1 sequence=2359

channel t1: restoring archive log

archive log thread=1 sequence=2360

channel t1: restoring archive log

archive log thread=1 sequence=2361

channel t1: restoring archive log

archive log thread=1 sequence=2362

released channel: t1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 04/01/2010 17:23:45

ORA-19507: failed to retrieve sequential file, handle="LOG_AFIS40_s42_t715190191

_p1", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Failed to process backup file

3          处理过程

通过查询metalink和google建议检查

On a Windows master server, run the command:

\VERITAS\NetBackup\bin\admincmd\bpgetconfig

DISALLOW_CLIENT_LIST_RESTORE = YES
DISALLOW_CLIENT_RESTORE = YES

建议改为

DISALLOW_CLIENT_LIST_RESTORE = NO
DISALLOW_CLIENT_RESTORE = NO

或netbackup 备份软件修改master server属性

选择client attributes

给allow client browse和allow client restore钩上即可

然后重新启动netbackup 服务,再执行restore archivelog 正常

p550a[oracle]$rman target / catalog rman_afis40/rman_afis40@rman

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

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

connected to target database: AFIS40 (DBID=830087130)

connected to recovery catalog database

RMAN>  run {

 allocate channel t1 type 'SBT_TAPE'

 parms 'ENV=(NB_ORA_SERV=gzbackup,

                  NB_ORA_SCHED=Default-Application-Backup,

                  NB_ORA_CLASS=ora_arch_afis40,

                  NB_ORA_CLIENT=p550a)';

 restore archivelog from sequence 2342;

 release channel t1;

 }

3> 4> 5> 6> 7> 8> 9>

allocated channel: t1

channel t1: sid=44 devtype=SBT_TAPE

channel t1: Veritas NetBackup for Oracle - Release 6.5 (2009050106)

Starting restore at 01-APR-10

archive log thread 1 sequence 2373 is already on disk as file /arch_dg/1_2373.dbf

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2342

channel t1: restoring archive log

archive log thread=1 sequence=2343

channel t1: restoring archive log

archive log thread=1 sequence=2344

channel t1: restoring archive log

archive log thread=1 sequence=2345

channel t1: restoring archive log

archive log thread=1 sequence=2346

channel t1: restoring archive log

archive log thread=1 sequence=2347

channel t1: restoring archive log

archive log thread=1 sequence=2348

channel t1: restoring archive log

archive log thread=1 sequence=2349

channel t1: restoring archive log

archive log thread=1 sequence=2350

channel t1: restoring archive log

archive log thread=1 sequence=2351

channel t1: restoring archive log

archive log thread=1 sequence=2352

channel t1: restoring archive log

archive log thread=1 sequence=2353

channel t1: restoring archive log

archive log thread=1 sequence=2354

channel t1: restoring archive log

archive log thread=1 sequence=2355

channel t1: restoring archive log

archive log thread=1 sequence=2356

channel t1: restoring archive log

archive log thread=1 sequence=2357

channel t1: restoring archive log

archive log thread=1 sequence=2358

channel t1: restoring archive log

archive log thread=1 sequence=2359

channel t1: restoring archive log

archive log thread=1 sequence=2360

channel t1: restoring archive log

archive log thread=1 sequence=2361

channel t1: restoring archive log

archive log thread=1 sequence=2362

channel t1: restored backup piece 1

piece handle=LOG_AFIS40_s42_t715190191_p1 tag=LOG_BACKUP params=NULL

channel t1: restore complete

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2363

channel t1: restoring archive log

archive log thread=1 sequence=2364

channel t1: restoring archive log

archive log thread=1 sequence=2365

channel t1: restoring archive log

archive log thread=1 sequence=2366

channel t1: restoring archive log

archive log thread=1 sequence=2367

channel t1: restored backup piece 1

piece handle=LOG_AFIS40_s46_t715190760_p1 tag=LOG_BACKUP params=NULL

channel t1: restore complete

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2368

channel t1: restoring archive log

archive log thread=1 sequence=2369

channel t1: restored backup piece 1

piece handle=LOG_AFIS40_s50_t715191214_p1 tag=LOG_BACKUP params=NULL

channel t1: restore complete

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2370

channel t1: restored backup piece 1

piece handle=LOG_AFIS40_s53_t715191468_p1 tag=LOG_BACKUP params=NULL

channel t1: restore complete

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2371

channel t1: restored backup piece 1

piece handle=LOG_AFIS40_s56_t715191721_p1 tag=LOG_BACKUP params=NULL

channel t1: restore complete

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=2372

channel t1: restored backup piece 1

piece handle=LOG_AFIS40_s59_t715191992_p1 tag=LOG_BACKUP params=NULL

channel t1: restore complete

Finished restore at 01-APR-10

released channel: t1

RMAN>

4          总结

在对netbackup 软件进行过修改配置时，最好master server和media server都重新启动下服务。