Re: Are offline backups an option, or a neccessity?

From: Satar Naghshineh <satarnag_at_worldsite.com>
Date: 1997/11/25
Message-ID: <347B868D.5DCB@worldsite.com>#1/1

ok boys n girls... a message from da masta of backup n recovery (ebonics)

For our 24 hour shop (unix system v, oracle ver 7.3.3), I do the following:
1) Pick a time of day in which your redo log files are not switching frequently.
2) Monday, Wendsday, Friday Hot table space backup

   Alter tablespace 'tablespace' begin backup    I then tar "tar cv - | (cd /oracle/backup; tar xv -)" the datafiles to a temporary disk location. I do this for all datafiles of all my Tablespaces. Then I use the Alter tablespace 'tablespace' end backup to release the writes to the redo log files. Then I transfer(copy) the datafiles to tape. Also it is a good idea durring these backups to backup your init<sid>.ora file and backup your control file.
3) Monday - Do a full database export. This will protect you from

a       console crash, fire,earthquake, ect. (depending on your
business       needs, you might want to do a full export on mondays and
and          incremental exports tuesday-saturday). 

4) Have at leaste two datafilefile back-ups of archived redo log files on disk (as well as on tape). Also, write a script to copy the Archived log files (every hour or so) from the destination file to a seperate disk (as well as on tape).

in a 24/7 shop, you (or at leaste I can't) afford to be down to back-up the database. Anyways, my two cents worth. Satar Naghshineh Received on Tue Nov 25 1997 - 00:00:00 CST