-
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.
You think I'm going to have an affair with you? --Stanley Kowalski
-
-
Find out what your customers requirments are first and then take it from there.
OCP 8i, 9i DBA
Brisbane Australia
-
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.
Say No To Plastics
-
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.
You think I'm going to have an affair with you? --Stanley Kowalski
-
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]
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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.
Jeff Hunter
-
If you have money, go for the BCV from EMC.
The fastest backup I have ever seen.
-
Originally posted by marist89
Hot backup every day during the slower times.
Will it be a full Hot Backup everyday or incremental. Is it backed up directly to the tape or on another hard drive first.
Originally posted by marist89
$ORACLE_HOME backed up once a week.
what exactly is meant by backup the oracle Home
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|