Re: full database restore

Ok Now the prvious two answer I think were not specfic to what actually you want to ask
when you take cold back you backup control file , datafile not the online redo log files (when database is shutdown)

now if you lose Control file , you can be in a little trouble, because when you copy the backedup Control file then the database data  files and Cotrol file are in Synchronisation , and Oracle database foud that there is no need of recovery , because SCN number in Control file and what in data files match, so it is quite logical that you got "No recovery require Message"

It is quite recomended that you always do mirring of your Control file.

so now to do a recover of Control file you need to hava copy of Control file from crashed system.

Now there is a way out if you lose Control file, you can re create a control
by create control file Command.
I will be sending you my personal Docs that how to create the Control file if you lose that.

Faheem Rao

sfitzgerald_at_centurytel.net (Sean Fitzgerald) wrote in message news:<605a2fd5.0109201029.3d89b671_at_posting.google.com>...
> Pay no attention to the previous answer. It is not correct.
>
> If you do a cold backup, the database is not running (you have done a
> shutdown). You backup up datafiles, control files and archive logs
> (not online redo logs).
>
>
> If you lose the entire machine/disk subsystem and restore everything
> you backed up, you will be able to recover to the point of the last
> archive log that you have.
>
> When you issue the recover command you tell oracle you are using a
> backup control file. Thus, you will be able to roll through all the
> archive logs you have from the point of the last backup. You will
> lose what was in the current online redo logs (not yet archived).
>
> You will have to open the database with the resetlogs option.
Received on Tue Sep 25 2001 - 04:04:30 CEST