Printable View
Hi guys,
need to check with you something, which backup software does most of the companies use for their Oracle DB?
Archserve or Vertias or some other brands?
My current Oracle DB is using Archserve.
While, in singapore, i think Vertias will be a bit more popular compare to Archserve.
Any feedbacks are most welcome.
Regards
Daniel
If you don't want to spend any more money, then go for RMAN. Now in 9i this product has become more reliable and robust. We use it for our production database backups.
I don't care what my Sysadmins use to backup the filesystems. I use RMAN and backup to disk. They come along later and copy my rman files to tape.
agreed, you can get fancy and backup directly to tape but the long and short of it is that a restore from a disk is much faster than a tape, consider backing up to disk and then have some os utility archive the backup to tape after a couple of daysQuote:
Originally posted by marist89
I don't care what my Sysadmins use to backup the filesystems. I use RMAN and backup to disk. They come along later and copy my rman files to tape.
hmm the shop I am now they dont use backup software, just use EMC timefinder, bcv the backup and that's it. Process used to take 5 hours now it takes 10 minutes
Guys thanks for the feedback.
While , i have heard of ECM Timefinder, but never hear or see it's being use in my country.
So,most of the Oracle Production DB, you guys are using the Rman to backup the existing database files?
Definately, backing up the files to a disk is much more faster to a tape drive. But, we have to look into the disk storage space.
Once again thanks and have a good days ahead.
Cheers!!
i am also using rman for backup.
can you just send me scripts for incremental backup
?
for example sunday full & whole week incremental..
regs
ramji
Check this link for a whole load of RMAN backup scripts.Quote:
Originally posted by ramji
can you just send me scripts for incremental backup
?
http://www.dbasupport.com/oracle/scr...y/RMAN_Backup/
Thanks to dbasupport.com !
Hi
most of the customers i have been to were small shops where they cannot afford to have separate Backup software..however the current folks use Veritas Netbackup it seems to be popular..also integrates with RMAN..
regards
Hrishy
The EMC Timerfinder is for the RICH Company's. You can use the RMAN its free.
Good Luck.
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!