Printable View
I like to have a tape copy off-site ASAP, so I would do it straight away (I presume your disk copy is not made across a WAN?)Quote:
Originally posted by stmontgo
. . . have some os utility archive the backup to tape after a couple of days
P.S. we use ArcServe
Our RMAN hot backups to disk begins at 5:30AM 6 days a week and lasts only 15 minutes. Next, Veritas Netbackup wakes up and copies /backup to tape. The window between RMAN ending and Netbackup beginning is monitored and kept small. Therefore, we have the best of both worlds - what Jeff said and what DaPi said.
The only danger is that Rman does not complete by the time Netbackup starts but I keep a close eye on the growing backup times and adjust. RMAN is invoked from a UNIX cron and Netbackup has it's own scheduler built in (here is the disconnect in scheduling). I configured it this way because I hate NetBackup's RMAN scripts.
I think you have not integrated RMAN With Netbackup? If you have you shouldnt have to worry about when netbackup starts to send the files to the tape :-?Quote:
Originally posted by gopi
The only danger is that Rman does not complete by the time Netbackup starts
AFAIK and using Tivoli Storage Manager it is TSM that invokes RMAN to backup and not a script that invokes RMAN
just wondering
You are absolutely correct and this is intentional. Let me tell you why....I hate the method that is needed in order to have Netbackup invoke RMAN:Quote:
Originally posted by pando
I think you have not integrated RMAN With Netbackup?
The Netbackup policy invokes a script as root, su's to Oracle and all the O/S environment is set, next the Netbackup environment is set and then the actual RMAN commands are in-streamed inside the script. I'm sorry but I hate this methodology (or I'm a little short in the smarts to do it - quite possibly). I am "DBA-centric" - personal preference dictactes that I work from UNIX/Oracle outwards.
Please blast me where necessary :) Thanks!
Hi Gopi
Can you elaborate..why you dont like the way RMAN has been integrated with veritas netbackup..i did not understand your exaplanation above..could you please elaborate..
regards
Hrishy
hrishy,
I think it's just personal choice. It's probably as simple as I don't like the scripting needed to work from inside Netbackup invoking RMAN. From my understanding here is the way it is done (please, please correct me where I am wrong):
- A Netbackup policy schedules a script that runs as root
- su's to Oracle
- set's the O/S environment for Oracle
- set's the environment variables for Netbackup itself to run under the oracle account that we just su'd to.
- All the rman commands are inside this very same script. Although these RMAN commands can be derived in this script I just feel the script is over all more complicated (when you read 1-7 below it may be more clear what I am talking about).
- Perhaps the bottom line is if Vertias can scheule a job to run as Oracle (o/s account) it would be better.
Now, here is my way of doing things. A script runs daily from a cron. The script is dynamic with regards to the SID (directory layout), date and time and whether it is a Hot or Cold backup
It runs as unix accoung oracle and...
1. prints the date/time
2. from sqlplus prints info from dba_data_files, v$controlfile, v$logfile, v$log a, v$logfile, v$archived_log
3. copys init.ora and password files to /backup
4. dynamically creates the RAMAN TAG to make the CATALOG pretty and the rest of the commands
5. invokes RMAN and runs
6. removes old stuff from disk
echo "remove old backups older 3 days..." | tee -a $LOG
find /backup/wmsp/rmanHOT_WMSP_t* -mtime +2 -exec rm -f {} \; | tee -a $LOG
find /backup/wmsp/*.dmp.gz -mtime +2 -exec rm -f {} \; | tee -a $LOG
find /backup/wmsp/init*.ora -mtime +2 -exec rm -f {} \; | tee -a $LOG
find /backup/repo/cold/*2003* -mtime +2 -exec rm -f {} \; | tee -a $LOG
echo "remove old archives older than 5 days .." | tee -a $LOG
find /archive/wmsp/*.arc -mtime +4 -exec rm -f {} \; | tee -a $LOG
7. reports on disks ie. df -k | tee -a $LOG
8. finally emails the log
mailx -s "${PREF}_${sname}_${now}.log" [email protected] < $LOG
##### PREF means either is HOT or COLD, SNAME is SID
In conclusion: Starting from the UNIX Oracle account to control RMAN is what I call "Oracle-centric". If I was patient enough, I can also code 1 thru 7 in the Netbackup script.
You asked for elaborations and got it. Again, I think I am pontificating personal preference or wrong understanding (short deadlines no formal education) here. thanx!