Problem with offline restore of a database
Date: Mon, 8 Sep 2008 11:23:00 -0700 (PDT)
We have a Windows server 2003 SP2 with all updates (as of 2 months ago) running Oracle 10g with some development and test data and a few schemas. The windows on the server has been damaged beyond repair, so we have setup another Windows server on another hardware. The ORacle backup we had is incomplete and not working very well. However, all the original Oracle database files and folders on the original server are in good shape and in tact.
Can anyone advise or point e inthe right direction of how to restore this database on the new server. Naively, I copied the entire Oracle database folder onto the new machine, but that obviously didn't work. I think it is because the new installation of Oracle just doesnt know about this, so just copying the files is not enough. But surely there must be an easy way of doing thisin Oracle. It is dead easy (almost) with SQL Server.
Any advice would be greeeeeeeeeatly and desperately appreciated.
N K Received on Mon Sep 08 2008 - 13:23:00 CDT