Re: Document on database restore

Hi,

If I understand your question, you need to restore all the db files to the server where it was before a crash ...

If you keep the same name of the db, the same locations of the files, ..., just be sure to copy all the files (data, control, redo), and you will be able to restart the original instance.

Dias

chrisforbis_at_yahoo.com (Chris Forbis) wrote in message news:<f2dc430d.0208221526.313c66a5_at_posting.google.com>...
> Does anyone have a link to a step by step document outlining what
> would need to be done to copy all database files from one database to
> anotehr one, and bring a NEW instance up on this other db server with
> the files that where just copied. Then after that RESTORE all archive
> log files to get an up to the second copy of the db?
>
> Here is the goal in case I confused you all as much as I think I did
> me :)
>
> I have a system with a 4 gig DB on it. If this system crashes (if), I
> need to bring a new system up, with the HOT backup from the night
> before. Then because I have the archive logs copies to a nutral
> server, I need to move them back to the new server and so a restore,
> getting back to where the other hardware failed.
Received on Fri Aug 23 2002 - 16:19:48 CDT