oracle----一客户TSM备份脚本

---level0_20110719.txt

run{
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect allocate channel t2 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/test@rac2;
sql 'alter system archive log current';
backup
incremental level 0
filesperset 5
format 'db_%d_%t_%s_%p_%T'
(database include current controlfile);
release channel t1;
release channel t2;
}

--level1_20110719.txt

run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt) ' connect sys/test@rac1;
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt) ' connect sys/test@rac2;
backup
incremental level 1
filesperset 5
format 'db_%d_%t_%s_%p_%T'
(database include current controlfile);
release channel t1;
release channel t2;
}

--arch_20110719.txt

sql 'alter system archive log current' ;
run
{
allocate channel a1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt) ' connect sys/test@rac1;
allocate channel a2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt) ' connect sys/test@rac2;
backup filesperset 10 format 'arch_%d_%t_%s_%p_%T' archivelog all delete input;
release channel a1;
release channel a2;
}

--delbackup_20110720.txt

rman target /
allocate channel for maintenance device type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/test@rac1;
allocate channel for maintenance device type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/test@rac2;
report obsolete;
delete force noprompt obsolete redundancy=15 device type sbt_tape;
crosscheck backup;
delete force noprompt expired backup device type sbt_tape;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26078027/viewspace-1052776/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26078027/viewspace-1052776/