Moving database from Win NT to Win 2000

[stsmuthu]

I have a oracle 8.1.7 database on Windows NT.
I am planning to move this database to Windows 2000, the oracle version is same.

What is the procedure to follow ? Is copying data/log/control files from NT to 2000 will be ok? Any special precautions to be taken ?

Urgent please.

[pando]

urgent? plz stop using that word, you post it if we think we can help we will

this is not metalink ok? there is no priorities here we do this for free, I spend my boss money here (oh yes because I do this from work )

regarding your question you can simply clone it, get a controlfile ASCII copy by issueing alter datbaase backup controlfile to trace then shutdown your database make a cold backup and restore to win 2k server with SAME PATHS if you dont want to modify your controlfile

now you have to modify a bit your controlfile

change
CREATE CONTROLFILE REUSE DATABASE "SIMP" NORESETLOGS ARCHIVELOG
to
CREATE CONTROLFILE REUSE SET DATABASE "SIMP" RESETLOGS ARCHIVELOG

[stsmuthu]

Thanks a lot

My thoughts are in sync with yours on the subject.

[oravijay]

Hi Pando,

Why we should change the controlfile.
I tried moving a database from Windows NT to Windows 2000 and started the database
by just re-creating the service in the new Windows 2000 server and bingo.....it worked.

If you are suggesting to re-create the controlfile for some reason, pls explain it.

Thanks.
Vijay.

[cheland]

Yes, I too wonder why the control file change is necessary in this case if you are not changing db name or paths.