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

From: <fitzjarrell_at_cox.net>
Date: Thu, 20 Dec 2007 07:42:55 -0800 (PST)
Message-ID: <3e260f1f-7a08-4c9c-9e9b-9fca2fed013c@e23g2000prf.googlegroups.com>

On Dec 20, 9:34 am, noumian <n.nou..._at_gmail.com> wrote:
> "Copying all of the files over (including the controlfile creation
> script, the init.ora or spfile.ora) to the destination machine"
> which files exacltly?
> the folders : oradata?flash_recovery_area?admin? (that they are in my
> oracle base)
> and all the file in my oracle home?

ALL of the DATAFILES for the database you want to CLONE. Also the init.ora file for that database (or the spfile if that's what you're using) AND the script you created to recreate the controlfile.

The more you write the more you should simply create a new database on the destination server, use exp to extract the data and objects from the source then use imp to put those into the new database. Obviously cloning a database is too difficult a task for a DBA with apparently less than 6 months experience.

David Fitzjarrell Received on Thu Dec 20 2007 - 09:42:55 CST