問題簡述：netbackup rman restore archivelog 報ora-19511錯誤，導致恢復歸檔日誌不成功。

作業系統：aix 5.3

資料庫：oracle 9.2.0.6

     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

透過查詢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都重新啟動下服務。