Re: full database restore

Hi there,

   I think you are mixing up what cold and hot backup are. First of all, if you are running the archivelog mode, you don't have to shutdown the database to do a cold backup. Cold backup is meant for when a little lost of data is okay (read only data) that you can afford to do a shutdown cold backup from time to time say every 8 hours or 12 hours. For cold backup, you backup all the database files; datafiles, control files, redo logs but not the archive logs. In case of crash, just copy everything that you backup to the new disks or locations and you can startup just like that!

  For hot backup, with archive mode on, you hotbackup the tablespaces(normally) and copy the physical files to your backup media (after you issue alter tablspace xxx begin backup, before you issue the end backup), also copy the archive logs, control files, and redo logs. In case of crash, depends on degree, you can restore the physical files to the original location and issue the alter database recover ... Specific commands, you have to check it out.

  This is only high level

Allan W. Tham
DBA Received on Wed Sep 19 2001 - 04:45:38 CEST