Re: Restoring from Hot Backups?

>In article <4588vj$so$1_at_mhafm.production.compuserve.com> Robert Barrell
 writes:
> Many people have posted questions recently about making hot backups, but I
>would like to know the next step: how to recover the database from a hot backup
>should it be necessary. Our DBA just got us started on hot backups using the
>script found in the "Oracle DBA Handbook" from Oracle Press. The thing is, the
>book isn't very clear on how to recover a database if one restores the tape so
>created. Since this is new territory for us, our DBA doesn't know either; but
>we would like to restore a tape to another machine to verify that we will be
>able to recover from a crash should one occur. So, if anyone would be kind
>enough to post step-by-step instructions for recovery from a hot backup, we
>would greatly appreciate it. Thanks.
>
> - Rob -
>
>

First off, I must say that it is better from an administrative purposes to have an occasional ( periodic ) cold backup along with the hot backup. In your case, restore the entire hot backup and apply the online-redo logs to this database. Then use the command ALTER DATABASE RECOVER LOGFILE 'logfile_name'. This applies the redo logs on to your database, and makes sure that you have full point-in-time recovery. Of course, this is just the general idea. The details are in Chapter 19 of the Server Administrator's Guide.

Nalini

Nalini Vallampati
UNIX Admin/Oracle DBA
AT&T Capital - Global Information Solutions Miamisburg, OH 45342 Received on Mon Oct 09 1995 - 00:00:00 CET