Re: Hot Backups...am I off base??

Valerie

When you have created the backup script and done your backups make sure you test a recovery with it. There is nothing worse than having to recover a prod database and finding your backups are useless.

john

At 10:35 AM 8/4/00 -0800, Heidi_Schmidt_at_gillette.com wrote:
>
>Valerie,
>
>If there is room cover all bases and have as many variations on backup of
>data as you need
>then do it. It is easier to cut back than to try to elbow your way in
>later.
>
>I try to
> export either schema or full database
> execute a hot backup
> backup the datafiles to DLT
>
>On a UNIX file system (without RAID) the disks have actually 95% of the
>disk available to use
>(this is the short explanation of what formatting and mkfs is doing)
>We see the numbers offset by 5% so if it is 100% full it is actually 95%
>full.
>
> The only issue I could see with more than one backup affecting
>housekeeping is that the disk is at 80 or more % capacity and if more was
>placed on it that would degrade disk write/read performance.
>
>Otherwise it is just an aesthetic dilemma.
>
>My concern would be if the backup fails but the hotbackup is deleted
>anyhoo. Then what a dilemma unless the one process won't kick off without
>the others check of success in the backup log.
>
>Good luck.
>
> Heidi
>
>
>
>
>
>
> Webber Valerie H
>
> <Valerie.H.Webbe To: Multiple recipients of
>list ORACLE-L
> r_at_irs.gov> <ORACLE-L_at_fatcity.com>
>
> Sent by: cc:
>
> root_at_fatcity.com Subject: Hot Backups...am I
>off base??
>
>
>
>
> 08/04/00 11:58
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>I am writing Korn shell scripts to create nightly hot backups on UNIX (SUN
>Solaris.)
>
>
>Another "DBA" (ex-System Admin I might add) recommends 1. making a hot
>backup of the database, 2. make a system backup, 3. then DELETE the hot
>backup we just created relying only on the system backup with a verify
>option. He say this is good for housekeeping on the system.
>
>
>I highly opposed this scenario. There is plenty of space available on the
>system for the backup files so that is not an issue. I'd rather have both..
>the system backup and the hot backup on disk drives.
>
>
>Am I off my rocker not to rely solely on the system backup?
>
>
>Would any of you use this strategy in production???
>
>
>Thanks in advance!
>Val
>Valerie H. Webber
>Management Systems Designers, Inc
>Valerie.H.Webber_at_m1.irs.gov
>704-569-1002 x107
>
>
>
>
>
>
>
>
>
>
>--
>Author:
> INET: Heidi_Schmidt_at_gillette.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Fri Aug 04 2000 - 14:23:40 CDT