Re: Newbie Question RE: cold backup

Yes, be certain you are backing up all the files including the control files, redo-logs, etc....
What I would suggest is obviously testing this as you are about to do, but also take full database export prior to doing your file copies then proceed by coping all your files to tape including the export file of the full database. Also keep this export file on-line so that tables accidentally dropped in the development environment can be restrored in no time at all and you could, if required, re-build the entire database with this export file.

Good Luck , Robert Prendin

"Judy Halter" <jhalter_at_shore.intercom.net> wrote:

>We're running Oracle 7.3.3.0 on NRC SV4 UNIX and developers are using
>Designer to develop applications. I have set up the cron job to shut the
>database down before doing our nightly tape backup. Should we be able to
>restore our entire database from this tape backup? I intend to test this
>as soon as possible.
>--
>Judy Halter
Received on Sun Mar 15 1998 - 00:00:00 CST