[root@testDB-rac2 full]# more backup.sh
#!/bin/ksh
date >>/opt/tivoli/tsm/backup/full/rman.log
echo “Schedule is starting” >>/opt/tivoli/tsm/backup/full/rman.log
su - oracle -c /opt/tivoli/tsm/backup/full/rman.sh
date >>/opt/tivoli/tsm/backup/full/rman.log
[root@testDB-rac2 ~]# more /opt/tivoli/tsm/backup/full/rman.sh
echo “Backup Starting” >>/opt/tivoli/tsm/backup/full/rman.log
date >>/opt/tivoli/tsm/backup/full/rman.log
rman target / catalog admin/admin@catalog12 msglog /opt/tivoli/tsm/backup/full/rman.log append @/opt/tivoli/tsm/backup/full/rman.rmn
echo “Backup End” >>/opt/tivoli/tsm/backup/full/rman.log
date >>/opt/tivoli/tsm/backup/full/rman.log
[root@testDB-rac2 ~]# more /opt/tivoli/tsm/backup/full/rman.rmn
allocate channel for maintenance type disk;
change archivelog all validate;
release channel;
report obsolete;
allocate channel for maintenance device type ‘sbt_tape’ parms
‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
delete noprompt obsolete;
allocate channel for maintenance type disk;
delete noprompt obsolete;
RUN {
allocate channel t1 type ‘sbt_tape’ parms
‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
backup incremental level 0 database include current controlfile format ‘df_%t_%s_%p’ filesperset=10;
#backup filesperset 10 format ‘df_%t_%s_%p’ (database);
sql ‘alter system archive log current’;
backup filesperset 20 format ‘al_t%t_s%s_p%p’ (archivelog all delete input);
RELEASE CHANNEL t1;
}
exit;
