Re: How to restore a cold backup?

1. Yes. This is a fairly special case: Win2K = WinNT. Normally the only method to copy a database between O/S is export/import.
2. I think you're a bit confused here: Any database you create on the new server will have absolutely nothing to do with the restoration. If the question is whether it matters where ORACLE_HOME is located then, no it doesn't matter.
3. See 2.
4. It's not complex at all. The only kicker here is that you need to know what you are doing. You should first read Howard J. Rogers' excellent documents or, failing that, the Oracle Backup and Recovery documentation.

Anthony Hogan.

Alessandro Nazzani wrote:
>
> Dear all.
>
> I have a "cold" backup (physical copy - after db shutdown - of all data
> files, control files, redo logs and init files) of a Oracle 8i db (WinNT
> 4.0).
>
> Now I'd like to restore this backup on a new PC with Win2k Server.
>
> Questions:
>
> 1) Is it possible?
>
> If yes:
>
> 2) Should I install Oracle on the new PC with the *exact* same parameters,
> names, etc. as the old db, or it doesn't really matter?
> 3) Does it matter if the drive letter where I install Oracle is not the same
> as the old db?
> 4) Can I simply Shutdown / Replace all the files of the new db with the
> corresponding file of the backup / Restart, or is it a bit more complex?
>
> TIA for your attention.
>
> Alessandro
Received on Wed May 29 2002 - 04:57:43 CDT