If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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.

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.

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.

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.

1. Hot backup every day during the slower times.
2. Archived redo logs backed up every 8 hours. Deleted with the Hot backup.
3. $ORACLE_HOME backed up once a week.