- 论坛徽章:
- 0
|
TSM备份出现奇怪问题，请高手进入。
平台环境：linux redhat AS4（TSM服务器），AIX53-04-CSP（TSM客户机），数据库oracle 92-06 RAC 。存储：DS4800。 4800在TSM备份服务器上的建立了2个文件系统/rac2及/rac3作为存储池，每个文件系统为4T多。
有2台客户机，P590A1（数据量很小，4G多） 、P570A1（数据量很大，400G多），皆备份到存储池RAC2即文件系统/rac2下。
590A1 备份数据库成功，而570A1备份数据库产生的文件到一定的大小后就抱错失败，具体如下：
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: U570P (DBID=312940931)
connected to recovery catalog database
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms
3> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> sql 'alter system archive log current';
5> backup archivelog all delete input ;
6> backup INCREMENTAL LEVEL 0 database;
7> sql 'alter system archive log current';
8> backup archivelog all ;
9> backup current controlfile;
10> release channel t1;
11> }
12>
allocated channel: t1
channel t1: sid=53 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0
sql statement: alter system archive log current
Starting backup at 01-FEB-07
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=507 recid=48 stamp=613413396
input archive log thread=1 sequence=508 recid=50 stamp=613413408
input archive log thread=2 sequence=217 recid=49 stamp=613413442
input archive log thread=2 sequence=218 recid=51 stamp=613413457
channel t1: starting piece 1 at 01-FEB-07
channel t1: finished piece 1 at 01-FEB-07
piece handle=07i8vsh4_1_1 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:00:26
channel t1: deleting archive log(s)
archive log filename=/archlog/u570p1/1_507.dbf recid=48 stamp=613413396
archive log filename=/archlog/u570p1/1_508.dbf recid=50 stamp=613413408
archive log filename=/archlog/u570p2/2_217.dbf recid=49 stamp=613413442
archive log filename=/archlog/u570p2/2_218.dbf recid=51 stamp=613413457
Finished backup at 01-FEB-07
Starting backup at 01-FEB-07
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00014 name=/dev/rhn_data051
input datafile fno=00016 name=/dev/rhn_data053
input datafile fno=00018 name=/dev/rhn_data055
input datafile fno=00020 name=/dev/rhn_data057
input datafile fno=00022 name=/dev/rhn_data059
input datafile fno=00024 name=/dev/rhn_data061
input datafile fno=00026 name=/dev/rhn_data063
input datafile fno=00028 name=/dev/rhn_data065
input datafile fno=00030 name=/dev/rhn_data067
input datafile fno=00032 name=/dev/rhn_data069
input datafile fno=00034 name=/dev/rhn_data071
input datafile fno=00036 name=/dev/rhn_data073
input datafile fno=00038 name=/dev/rhn_data075
input datafile fno=00040 name=/dev/rhn_data077
input datafile fno=00042 name=/dev/rhn_data079
input datafile fno=00044 name=/dev/rhn_data081
input datafile fno=00046 name=/dev/rhn_data083
input datafile fno=00048 name=/dev/rhn_data085
input datafile fno=00050 name=/dev/rhn_data087
input datafile fno=00052 name=/dev/rhn_data089
input datafile fno=00076 name=/dev/rhn_data102
input datafile fno=00084 name=/dev/rhn_data110
input datafile fno=00087 name=/dev/rhn_data113
input datafile fno=00075 name=/dev/rhn_data101
input datafile fno=00002 name=/dev/rhn_undo11
input datafile fno=00077 name=/dev/rhn_data103
input datafile fno=00088 name=/dev/rhn_data114
input datafile fno=00095 name=/dev/rhn_data091
input datafile fno=00061 name=/dev/rhn_data099
input datafile fno=00007 name=/dev/rhn_data044
input datafile fno=00009 name=/dev/rhn_data046
input datafile fno=00011 name=/dev/rhn_data048
input datafile fno=00013 name=/dev/rhn_data050
input datafile fno=00063 name=/dev/rhn_data032
input datafile fno=00065 name=/dev/rhn_data034
input datafile fno=00067 name=/dev/rhn_data036
input datafile fno=00069 name=/dev/rhn_data038
input datafile fno=00071 name=/dev/rhn_data040
input datafile fno=00073 name=/dev/rhn_data042
input datafile fno=00091 name=/dev/rhn_data117
input datafile fno=00093 name=/dev/rhn_data119
input datafile fno=00001 name=/dev/rhn_system
input datafile fno=00003 name=/dev/rhn_index
input datafile fno=00006 name=/dev/rhn_user
input datafile fno=00055 name=/dev/rhn_data093
input datafile fno=00085 name=/dev/rhn_data111
input datafile fno=00094 name=/dev/rhn_data120
input datafile fno=00096 name=/dev/rhn_data121
input datafile fno=00098 name=/dev/rhn_data123
channel t1: starting piece 1 at 01-FEB-07
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 02/01/2007 16:37:47
ORA-19502: write error on file "08i8vshv_1_1", blockno 1496065 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1311E (RC11) Server out of data storage space
Recovery Manager complete.
开始是怀疑存储池没有空间，检查后发现存储池空间足够。
Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
------------------------ ----------- ---------- --------- ----- --------
/rac2/00000004.BFS RAC2 RAC2 4,096.0 21.8 Filling
/rac2/00000006.BFS RAC2 RAC2 4,094.0 100.0 Full
/rac2/0000000A.BFS RAC2 RAC2 4,095.2 100.0 Full
/rac2/0000000B.BFS RAC2 RAC2 4,095.2 100.0 Full
/rac2/0000000C.BFS RAC2 RAC2 4,096.0 60.7 Filling （此为失败时的卷）
/rac3/00000005.BFS RAC3 RAC3 4,096.0 1.6 Filling
我存储池RAC2 最大允许100个临时卷，每个临时卷 大小为4G。
还有timeout时间也设置很大，不会是时间的问题。请各位老大支持支持。小弟没招了。
RMAN脚本如下：
run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system archive log current';
backup archivelog all delete input ;
backup INCREMENTAL LEVEL 0 database;
sql 'alter system archive log current';
backup archivelog all ;
backup current controlfile;
release channel t1; |
|
免费注册
发表于 2007-02-01 17:36
