Re: moving oracle database 9 from another computer to another one

On Dec 19, 2:32 pm, noumian <n.nou..._at_gmail.com> wrote:
> oracle version : 9.2.0.4
> Os source : SUSE linux
> Os destination ; SUSE linux

I find it appalling that an OCP DBA needs to be told this information.

That being the case you clone your database manually by:

Installing Oracle 9.2.0.4 on the destination machine Setting the proper Oracle environment variables on the destination machine
Creating a controlfile script by issuing the 'alter database backup controlfile to trace;' command
Shutting down the source database in normal or immediate mode Copying all of the files over (including the controlfile creation script, the init.ora or spfile.ora) to the destination machine in the same locations to make it easier on you
Configuring and starting the listener on the destination machine Starting the database nomount on the destination machine Creating a new controlfile with the script Opening the database resetlogs
Shutting down the cloned database
Taking a cold backup of the newly cloned database Starting the cloned database

You can also use RMAN to duplicate your database. Read about that here:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc2.htm#462471

I would be VERY careful when doing any of this; I really believe you need a qualified (meaning EXPERIENCED) DBA to do this task, as even though you profess to be OCP you're not qualified (in my opinion) to undertake it.

David Fitzjarrell Received on Wed Dec 19 2007 - 15:44:15 CST