Hello there dba's
just curious, what backup software(s) are you guys using? is RMAN and hot file backups (and exp) enough? or do you recommend a commercial backup software? also, some suggestion on backup hardware would be nice. Thanks.
Printable View
Hello there dba's
just curious, what backup software(s) are you guys using? is RMAN and hot file backups (and exp) enough? or do you recommend a commercial backup software? also, some suggestion on backup hardware would be nice. Thanks.
RMAN
+
http://www.veritas.com/products/cate...productId=nbux
+
http://www.storagetek.com/prodserv/products/tape/9740/
= success everytime.
Find out what your customers requirments are first and then take it from there.
Hi Jeff,
You have suggested 3 different solutions for backup. But, in most of the places there will be some
constraints like
1. Cost involved in buying all the required softwares
2. Cost involved in buying the necessary storage devices etc.
That is true in my case also.
This is what I follow:
1. Every week I take a cold backup and move it to the backup server.
2. We have veritas backup agent which will take online backup of the databases in a daily
basis and move them to the (same) backup server.
3. Users will take a user level export on a daily basis.
In this kind of a situation what other method can be followed.
Thanks.
Vijay.
thanks for the reply Jeff, I'd be interested to hear from other people as well. Also, it would be nice to hear about their backup and recovery strategies too for databases of different sizes, from 100 GB's to multi-terabyte databases.
shell scripts + sqlbacktrack + control-m
Hi Guys,
I would also like to hear from the Oracle Gurus and those who work in Big shops what their backup strategies are , and how do they go about it.
This will allow people like me who work in small shops with small databases 5-10 Gigs a peek into the real world.
When it comes to solid backup strategies i have no clue and the only strategy we small timers generally follow is a full cold backup every day/week and full exports.
Hence I would request on behalf of myself and my fellow members a brief peek into the real world of backup and recovery. It would be nice if you all share your experience and also point out some case studies which will help us gear to be better DBA's.
Thanks a lot in Advance.
Ronnie
ronnie_yours@yahoo.com
[Edited by ronnie on 05-07-2002 at 09:51 AM]
1. Hot backup every day during the slower times.Quote:
Originally posted by ronnie
Hence I would request on behalf of myself and my fellow members a brief peek into the real world of backup and recovery. It would be nice if you all share your experience and also point out some case studies which will help us gear to be better DBA's.
2. Archived redo logs backed up every 8 hours. Deleted with the Hot backup.
3. $ORACLE_HOME backed up once a week.
If you have money, go for the BCV from EMC.
The fastest backup I have ever seen.
Will it be a full Hot Backup everyday or incremental. Is it backed up directly to the tape or on another hard drive first.Quote:
Originally posted by marist89
Hot backup every day during the slower times.
what exactly is meant by backup the oracle HomeQuote:
Originally posted by marist89
$ORACLE_HOME backed up once a week.