2006-9-10 18:17
haomao1879
rman备份数据库错误求助
rman备份数据库错误求助
本人今天安装 配置了 tsm及其中的tdpo组件,参数文件皆正确,但是备份数据库出现个奇怪的问题,如下 :
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ZGCDB (DBID=2176649540)
connected to recovery catalog database
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> backup
4> format 'df_%t_%s_%p'
5> (database);
6> release channel t1;
7> }
8>
allocated channel: t1
channel t1: sid=18 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
Starting backup at 11-SEP-06
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/11/2006 06:25:50
ORA-00600: internal error code, arguments: [525], [0x70000000EFCEDF8], [5], [library cache], [5], [0x700000000025BF0], [device information], []
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 25: Not a typewriter
Additional information: 16
Recovery Manager complete.
但是我备份归档日志倒成功,具体如下 :
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ZGCDB (DBID=2176649540)
connected to recovery catalog database
RMAN> sql 'alter system archive log current';
2> run {
3> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
5> sql 'alter system switch logfile';
6> backup
7> filesperset 10
8> format 'arch_%t_%s.dbf'
9> tag 'archivelog backup'
10> archivelog like '/oracle/oradata/ZGCDB/archlog/1_%.dbf'
11> delete input;
12> release channel t1;
13> release channel t2;
14> }
15>
sql statement: alter system archive log current
allocated channel: t1
channel t1: sid=18 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: t2
channel t2: sid=11 devtype=SBT_TAPE
channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0
sql statement: alter system switch logfile
Starting backup at 11-SEP-06
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=43 recid=29 stamp=600848099
input archive log thread=1 sequence=44 recid=30 stamp=600848578
channel t1: starting piece 1 at 11-SEP-06
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=1 sequence=45 recid=31 stamp=600848579
channel t2: starting piece 1 at 11-SEP-06
channel t1: finished piece 1 at 11-SEP-06
piece handle=arch_600848579_3.dbf comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:00:16
channel t1: deleting archive log(s)
archive log filename=/oracle/oradata/ZGCDB/archlog/1_43.dbf recid=29 stamp=600848099
archive log filename=/oracle/oradata/ZGCDB/archlog/1_44.dbf recid=30 stamp=600848578
channel t2: finished piece 1 at 11-SEP-06
piece handle=arch_600848579_4.dbf comment=API Version 2.0,MMS Version 5.2.0.0
channel t2: backup set complete, elapsed time: 00:00:16
channel t2: deleting archive log(s)
archive log filename=/oracle/oradata/ZGCDB/archlog/1_45.dbf recid=31 stamp=600848579
Finished backup at 11-SEP-06
released channel: t1
released channel: t2
Recovery Manager complete.
我的oracle rman中的设置如下:
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0/dbs/snapcf_ZGCDB.f'; # default
RMAN>
请大家指教是哪儿出了偏差!!!!!!!