发布时间 : 星期三 文章ORA-27206 解决更新完毕开始阅读6853fc0f581b6bd97f19eaba
ORA-27206 解决一例
现象:
RMAN备份日志中:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on d1 channel at 03/21/2012 12:24:50 ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file \v8n6e4ue_1_1_7144\blockno 19969 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text: ANS0322E (RC-72) no text available for this return code.
备份脚本:
ORACLE_SID=dshy2 export ORACLE_SID
rman log='/oracle/app/oracle/rman_scripts/dshyrman_level1_tsm.log' append < #execute script dshy_lv1backup; allocate channel d1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; allocate channel d2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; sql 'alter system archive log current'; backup incremental level=1 database format 'dshy_level1%T_%U_%s' tag='DSHYLEVEL1'; sql 'alter system archive log current'; backup archivelog all format 'dshy_level1%T_%s' delete input; release channel d1; release channel d2; } allocate channel for maintenance device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE =/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; crosscheck backup; DELETE NOPROMPT EXPIRED BACKUP; DELETE NOPROMPT OBSOLETE redundancy=7; allocate channel for maintenance device type disk; crosscheck backup; crosscheck archivelog all; DELETE NOPROMPT EXPIRED BACKUP; DELETE NOPROMPT OBSOLETE redundancy=7; 解决: 运行全备脚本无此报错,对比后去掉%U, 新脚本如下: ORACLE_SID=dshy2 export ORACLE_SID rman log='/oracle/app/oracle/rman_scripts/dshyrman_level1_tsm.log' append < #execute script dshy_lv1backup; allocate channel d1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; allocate channel d2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; sql 'alter system archive log current'; backup incremental level=1 database format 'dshy_1_%T_%s' tag='DSHYLEVEL1'; sql 'alter system archive log current'; backup archivelog all format 'dshy_1_%T_%s' delete input; release channel d1; release channel d2; } allocate channel for maintenance device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE =/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; crosscheck backup; DELETE NOPROMPT EXPIRED BACKUP; DELETE NOPROMPT OBSOLETE redundancy=7; allocate channel for maintenance device type disk; crosscheck backup; crosscheck archivelog all; DELETE NOPROMPT EXPIRED BACKUP; DELETE NOPROMPT OBSOLETE redundancy=7; 备份无报错,问题解决. 附: backup incremental level 0 database format='LEV0_%d_%t_%U_%s＿%p' %c 备份片的拷贝数 %d 数据库名称 %D 位于该月中的第几天 (DD) %M 位于该年中的第几月 (MM) %F 一个基于DBID唯一的名称,这个格式的形式为c-IIIIIIIIII-YYYYMMDD-QQ,其中IIIIIIIIII为该数据库的DBID，YYYYMMDD为日期，QQ是一个1-256的序列 %n 数据库名称，向右填补到最大八个字符 %u 一个八个字符的名称代表备份集与创建时间 %p 该备份集中的备份片号，从1开始到创建的文件数 %U 一个唯一的文件名，代表%u_%p_%c %s 备份集的号 %t 备份集时间戳 %T 年月日格式(YYYYMMDD)