通过netbackup对Oracle进行rman restore archivelog 报ora-19511错误处理过程

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:187

通过netbackup对Oracle进行rman restore archivelog 报ora-19511错误处理过程

1 概述问题简述:netbackup rman restore archivelog 报ora-19511错误,导致恢复归档日志不成功。操作系统:aix 5.3数据库:oracle 9.2.0.6 2 问题描述 p550a[oracle]$rman target / catalog rman/rman@rman Recovery Manager: Release 9.2.0.6.0 - 64bit Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: TEST (DBID=830087130)connected to recovery catalog databaseRMAN> 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_test, NB_ORA_CLIENT=p550a)'; restore archivelog from sequence 2342; release channel t1; } 3> 4> 5> 6> 7> 8> 9>allocated channel: t1channel t1: sid=44 devtype=SBT_TAPEchannel 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.dbfchannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2342channel t1: restoring archive logarchive log thread=1 sequence=2343channel t1: restoring archive logarchive log thread=1 sequence=2344channel t1: restoring archive logarchive log thread=1 sequence=2345channel t1: restoring archive logarchive log thread=1 sequence=2346channel t1: restoring archive logarchive log thread=1 sequence=2347channel t1: restoring archive logarchive log thread=1 sequence=2348channel t1: restoring archive logarchive log thread=1 sequence=2349channel t1: restoring archive logarchive log thread=1 sequence=2350channel t1: restoring archive logarchive log thread=1 sequence=2351channel t1: restoring archive logarchive log thread=1 sequence=2352channel t1: restoring archive logarchive log thread=1 sequence=2353channel t1: restoring archive logarchive log thread=1 sequence=2354channel t1: restoring archive logarchive log thread=1 sequence=2355channel t1: restoring archive logarchive log thread=1 sequence=2356channel t1: restoring archive logarchive log thread=1 sequence=2357channel t1: restoring archive logarchive log thread=1 sequence=2358channel t1: restoring archive logarchive log thread=1 sequence=2359channel t1: restoring archive logarchive log thread=1 sequence=2360channel t1: restoring archive logarchive log thread=1 sequence=2361channel t1: restoring archive logarchive log thread=1 sequence=2362released channel: t1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 04/01/2010 17:23:45ORA-19507: failed to retrieve sequential file, handle="LOG_TEST_s42_t715190191_p1", parms=""ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: Error received from media manager layer, error text: Failed to process backup file 3 处理过程建议检查On a Windows master server, run the command:\VERITAS\NetBackup\bin\admincmd\bpgetconfigDISALLOW_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/rman@rmanRecovery Manager: Release 9.2.0.6.0 - 64bit ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: TEST (DBID=830087130)connected to recovery catalog databaseRMAN> run { allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_SERV=gzbackup, NB_ORA_SCHED=Default-Application-Backup, NB_ORA_CLASS=ora_arch_test, NB_ORA_CLIENT=p550a)'; restore archivelog from sequence 2342; release channel t1; }3> 4> 5> 6> 7> 8> 9>allocated channel: t1channel t1: sid=44 devtype=SBT_TAPEchannel t1: Veritas NetBackup for Oracle - Release 6.5 (2009050106)Starting restore at 01-APR-10archive log thread 1 sequence 2373 is already on disk as file /arch_dg/1_2373.dbfchannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2342channel t1: restoring archive logarchive log thread=1 sequence=2343channel t1: restoring archive logarchive log thread=1 sequence=2344channel t1: restoring archive logarchive log thread=1 sequence=2345channel t1: restoring archive logarchive log thread=1 sequence=2346channel t1: restoring archive logarchive log thread=1 sequence=2347channel t1: restoring archive logarchive log thread=1 sequence=2348channel t1: restoring archive logarchive log thread=1 sequence=2349channel t1: restoring archive logarchive log thread=1 sequence=2350channel t1: restoring archive logarchive log thread=1 sequence=2351channel t1: restoring archive logarchive log thread=1 sequence=2352channel t1: restoring archive logarchive log thread=1 sequence=2353channel t1: restoring archive logarchive log thread=1 sequence=2354channel t1: restoring archive logarchive log thread=1 sequence=2355channel t1: restoring archive logarchive log thread=1 sequence=2356channel t1: restoring archive logarchive log thread=1 sequence=2357channel t1: restoring archive logarchive log thread=1 sequence=2358channel t1: restoring archive logarchive log thread=1 sequence=2359channel t1: restoring archive logarchive log thread=1 sequence=2360channel t1: restoring archive logarchive log thread=1 sequence=2361channel t1: restoring archive logarchive log thread=1 sequence=2362channel t1: restored backup piece 1piece handle=LOG_TEST_s42_t715190191_p1 tag=LOG_BACKUP params=NULLchannel t1: restore completechannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2363channel t1: restoring archive logarchive log thread=1 sequence=2364channel t1: restoring archive logarchive log thread=1 sequence=2365channel t1: restoring archive logarchive log thread=1 sequence=2366channel t1: restoring archive logarchive log thread=1 sequence=2367channel t1: restored backup piece 1piece handle=LOG_TEST_s46_t715190760_p1 tag=LOG_BACKUP params=NULLchannel t1: restore completechannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2368channel t1: restoring archive logarchive log thread=1 sequence=2369channel t1: restored backup piece 1piece handle=LOG_TEST_s50_t715191214_p1 tag=LOG_BACKUP params=NULLchannel t1: restore completechannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2370channel t1: restored backup piece 1piece handle=LOG_TEST_s53_t715191468_p1 tag=LOG_BACKUP params=NULLchannel t1: restore completechannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2371channel t1: restored backup piece 1piece handle=LOG_TEST_s56_t715191721_p1 tag=LOG_BACKUP params=NULLchannel t1: restore completechannel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=2372channel t1: restored backup piece 1piece handle=LOG_TEST_s59_t715191992_p1 tag=LOG_BACKUP params=NULLchannel t1: restore completeFinished restore at 01-APR-10released channel: t1RMAN>4 总结在对netbackup 软件进行过修改配置时,最好master server和media server都重新启动下服务。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】