Level 0

run {

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

delete obsolete;

delete archivelog all backed up 1 times to device type 'SBT_TAPE';

backup incremental level 0 database plus archivelog;

release channel t1;

}

Level 1

run {

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

delete obsolete;

delete archivelog all backed up 1 times to device type 'SBT_TAPE';

backup incremental level 1 database plus archivelog;

release channel t1;

}

ARCHIVELOG Backup Examples

backup archivelog all;

backup archivelog time between 'sysdate-12/24' and 'sysdate-11/24';

run {

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

backup archivelog time between 'sysdate-12/24' and 'sysdate-11/24';

delete noprompt obsolete;

release channel t1;

}

Monitoring Backup Progress

Automated Backup Example

This example peforms a weekly full and daily incremental backup to "tape" (TSM) and retains 30 days worth of logs.

rmantsm.ksh

Create this in /u01/dba/rman...

# ............................................................................

#

# Name /u01/dba/rman/rmantsm.ksh

# Purpose Run standard RMAN backup to TSM/TDP

# Usage Usually scheduled via 'oracle' crontab

# Return 0 = Success, 1 = Fail

# Parameters 0 = Level 0, 1 = Level 1, A - Archivelog

#

# ............................................................................

if [ $1 ]

then

LEVEL=$1

else

LEVEL=0

fi

function oradbenv

{

. /etc/profile

if [ -a ~/.profile ]

then

. ~/.profile

fi

if [ -a ~/.bash_profile]

then

. ~/.bash_profile

fi

}

oradbenv

case ${LEVEL}

in

0) rman target / cmdfile /u01/dba/rman/simpletsm0.txt

;;

1) rman target / cmdfile /u01/dba/rman/simpletsm1.txt

;;

A) rman target / cmdfile /u01/dba/rman/archivetsm.txt

;;

*) echo "ERROR: Supported levels are 0 or 1 or A"

exit 1

;;

esac

# EOF

simpletsm0.txt

Create this in /u01/dba/rman...

run

{

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

delete obsolete;

delete archivelog all backed up 1 times to device type 'SBT_TAPE';

backup incremental level 0 database plus archivelog;

release channel t1;

}

show all;

report unrecoverable;

report need backup;

list backup summary;

simpletsm1.txt

Create this in /u01/dba/rman...

run

{

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

delete obsolete;

delete archivelog all backed up 1 times to device type 'SBT_TAPE';

backup incremental level 1 database plus archivelog;

release channel t1;

}

show all;

report unrecoverable;

report need backup;

list backup summary;

archivetsm.txt

Create this in /u01/dba/rman...

run

{

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

backup archivelog all;

delete obsolete;

delete archivelog all backed up 1 times to device type 'SBT_TAPE';

release channel t1;

}

show all;

report unrecoverable;

report need backup;

list backup summary;

Cron Schedule

10 22 * * 6 /u01/dba/rman/rmantsm.ksh 0 >/u01/dba/rman/logs/rman.$(date +""\%d"").log 2>&1

10 02 * * 0,1,2,3,4,5 /u01/dba/rman/rmantsm.ksh 1 >/u01/dba/rman/logs/rman.$(date +""\%d"").log 2>&1

Check Logs

This finds all lines with an RMAN or ORA error, or an OS/MML level error whilst excluding information messages...

cd /u01/dba/rman/logs

grep -E 'RMAN-|ORA-|^ ' * | grep -v RMAN-08138 | grep -v RMAN-08120

Bibliography