Shifting a Database

[parisdba]

Hi,

Is it possible to shift a database from one machine to another without export and import. Here is what would like to do. I am running oracle 8.1.6.3 ON windows 2000 server (Hp machine) with datafiles,redo log files and control files on a NetApp Storage Device (Filer F720) .(log files and control files are mirrored on to the hp machine as well) Now what i would like to do is to change the hp server which runs oracle without changing the Filer. is it ossible to create a new datbase on the new machine and use the existing control files and redo log files so that i wont have to export and import.

thanks for your time
bye

 

[rcurva]

you can do that except for one file which you need to recreate, CONTROL FILES.

Try and search this command:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War