Veritas and rman

[timmy90210]

Can anyone provide me with a good overview on how rman and Veritas work. Our DBA left and all his custom scripting is not up to our enterprise standards. I am very familure with Veritas and SQL but I have yet to try to understand the big O.

Timmy.

 

[creakyjoe]

here's an example ora db backup (ora 9i) under netbackup -

rman script that netbackup runs.....

#!/bin/ksh

BACKUP_DIR=/home/TEST3/oracle;export BACKUP_DIR
NB_ORA_POLICY=CL_ORACLEDB_gentest3;export NB_ORA_POLICY

<shedload of ORACLE environment variables snipped for brevity !>

/u01/TEST3/app/oracle/product/9.2/bin/rman target=username/password@system.world catalog=username/password@RMAN.WORLD cmdfile=/home/TEST3/oracle/db-backup0-tape-gentest3.rcv > /home/TEST3/oracle/$LOGFILE





rcv file that the netbackup script calls.....

run {
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
allocate channel t3 type 'sbt_tape';

resync catalog;

# Backup the Database, control file, archivelogs, then deletes 1 copy of archivelogs.
backup full database plus archivelog delete input;

release channel t1;
release channel t2;
release channel t3;
}



works like a dream


Rich