Re: Correct backup ?

If I understand you correctly you want to use on-line backups (Hot backups, Warm backups, or whatever you want to refer to them as) as well as off-line. I would STRONGLY suggest you backup all of your tablespaces and corresponding datafiles as well as logs and control files in both online and offline mode.
Depending on the importance of your data (I assume VERY important) I would suggest incremental exports as well.

The more thorough your backup plan the better chance of up to the minute recovery.
I have written a Disaster Recovery Plan that documents all these things using real life disasters. IF you would like a copy as well as a copy of my online backup script let me know and I'd be glad to share them with you.

HTH!
Chris Larson
Oracle DBA
Control Data Systems
Christopher.D.Larson_at_cdc.com

>Hi Oracle Gurus,
>I am also interested in this situation. Please reply to me also
>Regards
>A.Lim
>
>On Tue, 23 Jan 1996, Pisano Fiore wrote:
>
> Hello Oracle friends.
>
> I am writing a backup procedure that consist of following step:
>
> a) take on-line backup of this tablespace
>
> a1) system
> a2) temp
> a3) tool
> a4) user
> a5) rbs
> a6) mytablespace
>
> b) make a copy of archived redo log files
>
> c) make a copy of control file
>
> I think to use this procedure every night by cron.
> My questions are:
>
> 1) Is this all to recovery every problem ?
>
> 2) If I use for my application only "mytablespace" I need to backup
> tools ,temp,user tablespace ?
>
>
> Thanks in advance!
> Pisano Fiore
> e-mail address <pisano_at_solaria.bsav.bull.it>
> phone 0-825-764388
> Bull Sud HN
> (Avellino) Italy
>
Received on Tue Jan 23 1996 - 19:40:56 CST