这是进行Oracle数据库的备份
执行q vol ,结果如下,oraclepool有5个已经full了:
Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
------------------------ ----------- ---------- --------- ----- --------
336AAB ORACLEPOOL 3582CLASS 786,373.9 100.0 Full
339AAB SYSBACKPOOL 3582CLASS 762,938.0 2.0 Filling
R00000 SYSBACKPOOL 3582CLASS 762,938.0 1.6 Filling
Z22468 SYSBACKPOOL 3582CLASS 762,938.0 2.0 Filling
Z22470 SYSBACKPOOL 3582CLASS 762,938.0 2.1 Filling
Z22471 SYSBACKPOOL 3582CLASS 762,938.0 9.0 Filling
Z22472 SYSBACKPOOL 3582CLASS 762,938.0 11.9 Filling
Z22473 ORACLEPOOL 3582CLASS 706,158.6 100.0 Full
Z22475 ORACLEPOOL 3582CLASS 762,938.0 53.1 Filling
Z22476 ORACLEPOOL 3582CLASS 786,778.8 100.0 Full
Z22477 ORACLEPOOL 3582CLASS 714,754.4 100.0 Full
Z22478 ORACLEPOOL 3582CLASS 787,841.1 100.0 Full
执行 q libv,结果如下:
Library Name Volume Name Status Owner Last Use Home Device
Element Type
------------ ----------- ---------- ---------- --------- ------- ------
3582LIB 336AAB Private TSM Data 4,097
3582LIB 339AAB Private TSM Data 4,114
3582LIB R00000 Private TSM Data 4,096
3582LIB Z22468 Private TSM Data 4,098
3582LIB Z22470 Private TSM Data 4,099
3582LIB Z22471 Private TSM Data 4,100
3582LIB Z22472 Private TSM Data 4,102
3582LIB Z22473 Private TSM Data 4,101
3582LIB Z22474 Private TSM DbBackup 4,107
3582LIB Z22475 Private TSM Data 4,106
3582LIB Z22476 Private TSM Data 4,105
3582LIB Z22477 Private TSM Data 4,104
3582LIB Z22478 Private TSM Data 4,103
下面是tsm lev1的备份日志 lev1.log:
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Feb 23 03:08:27 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: NNGAZF (DBID=3035808431)
using target database control file instead of recovery catalog
RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> backup incremental level 1 database format='XSDB_%d_%t_%U' filesperset=5 diskratio=0 database include current controlfile;
4> sql 'alter system archive log current';
5> backup format 'arch%t_%s_%r' diskratio=0 archivelog all delete all input;
6> release channel t1;
7> }
8>
9>
allocated channel: t1
channel t1: sid=1035 instance=nngazf1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
Starting backup at 23-FEB-09
channel t1: starting incremental level 1 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=/dev/rdb_zf_user
input datafile fno=00006 name=/dev/rdb_zf_lsanm01
input datafile fno=00007 name=/dev/rdb_zf_lsanm02
input datafile fno=00008 name=/dev/rdb_zf_lsanm03
input datafile fno=00009 name=/dev/rdb_zf_lsanm04
input datafile fno=00010 name=/dev/rdb_zf_lsanm05
input datafile fno=00011 name=/dev/rdb_zf_lsanm06
input datafile fno=00012 name=/dev/rdb_zf_lsanm07
input datafile fno=00013 name=/dev/rdb_zf_lsaimg01
input datafile fno=00014 name=/dev/rdb_zf_lsaimg02
input datafile fno=00015 name=/dev/rdb_zf_lsaimg03
input datafile fno=00016 name=/dev/rdb_zf_lsaimg04
input datafile fno=00017 name=/dev/rdb_zf_lsaimg05
input datafile fno=00018 name=/dev/rdb_zf_lsaimg06
input datafile fno=00019 name=/dev/rdb_zf_lsaimg07
input datafile fno=00020 name=/dev/rdb_zf_lsaimg08
input datafile fno=00021 name=/dev/rdb_zf_lsaimg09
input datafile fno=00022 name=/dev/rdb_zf_lsaimg10
input datafile fno=00036 name=/dev/rdb_xz_tbspt01
input datafile fno=00038 name=/dev/rdb_xz_tbspt02
input datafile fno=00039 name=/dev/rdb_xz_tbspt03
input datafile fno=00037 name=/dev/rdb_xz_indx
input datafile fno=00002 name=/dev/rdb_zf_undotbs1
input datafile fno=00004 name=/dev/rdb_zf_undotbs2
input datafile fno=00023 name=/dev/rdb_zf_lsaid01
input datafile fno=00024 name=/dev/rdb_zf_lsaid02
input datafile fno=00025 name=/dev/rdb_zf_sdlc01
input datafile fno=00026 name=/dev/rdb_zf_sdlc02
input datafile fno=00027 name=/dev/rdb_zf_sdlc03
input datafile fno=00028 name=/dev/rdb_zf_sdlc04
input datafile fno=00029 name=/dev/rdb_zf_hasdt01
input datafile fno=00030 name=/dev/rdb_zf_hasdt02
input datafile fno=00031 name=/dev/rdb_zf_hasdt03
input datafile fno=00032 name=/dev/rdb_zf_hasdt04
input datafile fno=00003 name=/dev/rdb_zf_sysaux
input datafile fno=00033 name=/dev/rdb_zf_hasid01
input datafile fno=00001 name=/dev/rdb_zf_system
input datafile fno=00034 name=/dev/rdb_xz_usr01
input datafile fno=00035 name=/dev/rdb_xz_web01
channel t1: starting piece 1 at 23-FEB-09
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 02/23/2009 03:11:49
ORA-19502: write error on file "jik824di_1_1", blockno 2049 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1329S (RC29) Server out of data storage space
Recovery Manager complete.
以下是备份脚本:
run{
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup incremental level 1 database format='XSDB_%d_%t_%U' filesperset=5 diskratio=0 database include current controlfile;
sql 'alter system archive log current';
backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete all input;
release channel t1;
}
收起