Yep, we do it atleast 4 times a week.

Alok

-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.[Email Address Removed] Tuesday, July 31, 2001 3:39 PM
To: Kumar, Alok; LazyDBA.com Discussion
Subject: RE: recover database


Hmmm....
Have you used this exact procedure before?
I am curious to know.
I always thought one needs to have the backup controlfile created as 'alter
database backup controlfile to <filename>' for recovering the db on a
different server.
I may be wrong here.
I do not not have my 'Backup and Recovery Handbook' with me to check this
out.
Pl let me know.

Thanks,

- Kirti Deshpande
Verizon Information Services
http://www.superpages.com

> -----Original Message-----
> From: Kumar, Alok [SMTP:Alok.[Email Address Removed] Sent: Tuesday, July 31, 2001 2:27 PM
> To: LazyDBA.com Discussion
> Subject: RE: recover database
>
> Hi,
>
> 1. Restore the hotbackup file to the new server.
> 2. Use the output of "alter datbase backup controlfile to trace" and
> modify
> to generate valid controlfile for the new location.
> 3. Create the controlfile.
> 4. Restore the archivelogs or later as prompted.
> 5. recover database using backup controlfile (it will use the controlfile
> u
> created in step 3)
> 6. Last Alter database open reset logs.
>
> Let me know you get stuck anywhere.
>
> Alok
>
Oracle LazyDBA home page