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.
$ORACLE_HOME is the software
Hot backup every day . (shell written for hot backup)
Archived Redologs backup every 4 hours.
Export backup taken once in a day .
Full Backup (par file wtitten in unix script )
Archived logs kept - last 15 days .
No Cold backup.
-- Pravin
But no tool used for above backups in our shop. Bcoz of the cost .
Quote:
Originally posted by ronnie
Will it be a full Hot Backup everyday or incremental. Is it backed up directly to the tape or on another hard drive first.
Yes, Full Hot backup directly to tape.
$ORACLE_HOME is the Oracle software.Quote:
what exactly is meant by backup the oracle Home
Quote:
Originally posted by marist89
Quote:
Originally posted by ronnie
Will it be a full Hot Backup everyday or incremental. Is it backed up directly to the tape or on another hard drive first.
Yes, Full Hot backup directly to tape.
$ORACLE_HOME is the Oracle software.Quote:
what exactly is meant by backup the oracle Home
Pardon my ignorance, but why will backing up oracle software be of any benefit.
Also Is your Hot backup full every day or incremental.
Thanks
Tamil selvan
Just for my info - i didnot get this -- go for BCV from EMC.
what is the full name for BCV & EMC.
--Pravin
If you lose the filesystem that contains the Oracle software, your choices are:Quote:
Originally posted by ronnie
Pardon my ignorance, but why will backing up oracle software be of any benefit.
1. restore the previous working software from tape.
2. re-install oracle
I prefer to restore the working software so I don't have to remember what options I had installed for this instance.
Yes, Full Hot backup every day. In my environment, my Mean Time To Recovery (MTTR) is so short it doesn't make sense to use Incrementals.Quote:
Also Is your Hot backup full every day or incremental.
http://www.emc.com/Quote:
Originally posted by pravin
Tamil selvan
Just for my info - i didnot get this -- go for BCV from EMC.
what is the full name for BCV & EMC.
--Pravin
I believe BCV is restricted to EMC platforms only...
in UNIX it is easier restoring software than install
if you work in windows then itīs up to you
BCV stands for Business Continous Volume.
EMC means EMC corporation, Boston,USA, a network storage company.
I think EMC name comes from the famous equation E=MCxC,
Einstein's theory about energy and mass. I am not sure.
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, do you use a shell script to do hot backups of datafiles and archived redo logs or do you use veritas?
I use RMAN to backup the database and archived logs. That way I don't have to worry about which media manager (Veritas, Brightstor) I am using.Quote:
Originally posted by TheSlob
Jeff, do you use a shell script to do hot backups of datafiles and archived redo logs or do you use veritas?
We have a 1/2 TB Datawarehouse in which we Hot backup daily and Cold Backup on Sundays. Also run exports on a number of schemas.
1. Hot backup full every day
2. Archive log transfer to standby database every two hrs.
3. ORACLE HOME backup every day
Is backing up only the oracle Home sufficient for this.Quote:
Originally posted by marist89
If you lose the filesystem that contains the Oracle software, your choices are:
1. restore the previous working software from tape.
2. re-install oracle
I prefer to restore the working software so I don't have to remember what options I had installed for this instance.
Dont we have to backup the registry (in case of windows) also because it has all the parameters.
Just restoring the software from the backup wont be enough.
Correct me if I am wrong.
Thanks
I don't know. I don't do Windoz.Quote:
Originally posted by ronnie
Dont we have to backup the registry (in case of windows) also because it has all the parameters.
I am sure that there must be something like the registry in unix also where information regarding oracle homes created on the server is stored along with lots of other info on the installed Home.Quote:
Originally posted by marist89
I don't know. I don't do Windoz.Quote:
Originally posted by ronnie
Dont we have to backup the registry (in case of windows) also because it has all the parameters.
there is no registry in unix, install linux in your PC and you will see
Full Export every night
Hotbackup every night
Cold backup 15 days
Archivelog backup every 1 hour
Quote:
Originally posted by Kishore
Full Export every night
Hotbackup every night
Cold backup 15 days
Archivelog backup every 1 hour
Any advantage of taking a cold backup everyday when you take a Kot Backup everyday.
How do you determine what your MTTR is and at what MTTR does a incemental backup makes sense.Quote:
Originally posted by marist89
[Yes, Full Hot backup every day. In my environment, my Mean Time To Recovery (MTTR) is so short it doesn't make sense to use Incrementals.
[Edited by ronnie on 05-08-2002 at 12:55 PM]
I mentioned that I am taking cold backup every 15 days not every day
Oops I am sorry,Quote:
Originally posted by Kishore
I mentioned that I am taking cold backup every 15 days not every day
I meant whats the advantage of taking a cold backup every 15 days when you already are taking a Hot Backup everyday.
Does it have any edge ....
isn't a full hot backup enough so that I don't have to do cold backups anymore? most of our servers should be up 24/7. Also, if archived logs are being multiplexed into several location do I still have to backup archived logs every hour?
I know this depends on the size of the database and the storage capacity of the backup medium but can you guys recommend how long should i keep archived redo logs before I delete them? Thanks.
Your MTTR is determined by your business model. You can figure out what your recovery time is by crashing your server and recovering it. If it takes you 1 hour to pull the database off tape and 1 hour to recover, your minimum MTTR is 2 hours. If it takes 1 hour to pull the data off tape, 1 hour to pull the incrementals off tape and 1 hour to recover, you have a minimum 3 hr MTTR.Quote:
Originally posted by ronnie
How do you determine what your MTTR is and at what MTTR does a incemental backup makes sense.
You only need the archived redo log files from before the last logswitch before the last backup.Quote:
Originally posted by TheSlob
can you guys recommend how long should i keep archived redo logs before I delete them? Thanks.
In other words, say at T0 a logswitch occurs. At T1 you start your hot backup. At T2 you end your backup. You need to have the archived redo logs from T0 to current.
Again, that depends on your business model. In my environment, everything has to be up 24X7 so a cold backup would be impossible.Quote:
Originally posted by TheSlob
isn't a full hot backup enough so that I don't have to do cold backups anymore?
As Jeff said, it depends on the business model. I am taking cold backup to test the recovery every 15 days. Taking backup is not sufficient unless you test them to recover the database.
If cold backup is not possible, test them with Hotbackup. Testing backups frequently is as important as taking backups.
I couldn't agree more. This is one of the top mistakes new (and some experienced) DBAs make every day.Quote:
Originally posted by Kishore
Testing backups frequently is as important as taking backups.
can somebody give an example on how one would go about taking incremental backups. I mean the strategy you would use to backup and recover.
Any pointers to white papers,Articles or case studies would also be very helpful.
Thanks
We use RMAN to backup our database (~150 Gig) to tape every night. We use Tivoli Storage Manager with TDP so the data goes directly to tape.
We implement the following incremental stategy:
Sun Mon Tues Weds Thurs Fri Sat
0 2 2 1 2 2 1
With this a 0 means FULL, 1 means back up everything that has changed since the last "1" or lower. 2 means back up everything that has changed since the last 2 or lower.
With this we do an incremental 0 (FULL) on Sunday. On Monday, everything that has changed since Sunday. On Tuesday, everything that has changed since Monday. On Weds, we do everything that has changed since SUNDAY. On Thursday, everything that has changed since Weds... and so on.
With this scheme we never have more than 4 days worth of backups to apply. So if the DB crashed on Friday, after the backup, we would have to apply Sun, Weds, Thurs & Friday, plus any archive logs since the Friday backup.
Obviously this will take longer to restore than doing FULL backups every night, but cost of tapes and time to do backups was a determining factor for us.
In addition, we do full exports every night and backup our $ORACLE_HOME every night.
Hope that helps you with an Incremental Strategy!
Jodie
and what about windows. They have registry in windows. How do you backup and restore the oracle home in windiws 2000Quote:
Originally posted by pando
there is no registry in unix, install linux in your PC and you will see
How do you test a backup. Is it by bringing the backup database on another machine or there are some other ways...Quote:
Originally posted by marist89
I couldn't agree more. This is one of the top mistakes new (and some experienced) DBAs make every day.Quote:
Originally posted by Kishore
Testing backups frequently is as important as taking backups.
Thanks