Re: Frequency of Hot Backups

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 30 Mar 2002 21:55:18 GMT
Message-ID: <avqp8.143219$af7.72443@rwcrnsc53>

How long do you want it to take to recover? If you take hot backups 1/year then if you have to recover you are going to have to allow Oracle apply all the archive logs for the file you lost to bring it up to date. (assuming you lost a file) Depending upon how fast your system is and how much data is changed since the last hot backup this might take quite awhile.

Even if I had a stand by database (trying to convince management to do that) I would still do frequent hot backups. When it comes to backup I am a belt and suspenders type. (make sure you have multiple ways to get the data back. For example, in a perfect world I would

1. have my archive logs mirrored to multiple destinations
2. have a stand by database
3. do frequent hot backups
4. do frequent exports (I know it is not a back up, but nice to have the

data at a point in time. Also it makes sure that all the data blocks are okay; no block corruption due to a possible hardware problem.) 5. triple mirror (so I could break a mirror, backup the files on the "broken" mirror and resilver)

Some might add replication to a remote site. I take hot backups daily.

Jim
"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns91E18909E9FAASunnySD_at_68.6.19.6...
> Assume that the instance is running in archive mode.
>
> What is the frequency your organization does hot backups?
>
> If you have a "stand by" database against which you
> keep applying archived redo logfile, in theory you
> would/could/should never have to take another backup.
> Right?
>
> So what is the longest "reasonable" period between
> actual Oracle hot backups?
Received on Sat Mar 30 2002 - 15:55:18 CST