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

In article <347B868D.5DCB_at_worldsite.com>, Satar Naghshineh <SatarNag_at_amtec-audiotext.com> wrote:
>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

You do this online?

>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

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!