database clone

[beechill4]

Hi,

I have a 9.2.0.7 enterprise edition database.

Is it possible for me to clone it onto another server running 9.2.0.7 standard edition?

Thanks!

 

[maswien]

I guess you will get error like " feature is not installed " or similiar if you use the Enterprise feature in the source database.

 

[SantaMufasa]

Beechill,

How "cloney" do you want the second database? Do you want to use the same data files from the source database? Do you simply want the logical data content of the source database in the target database?

I'll post an answer based upon your clarifications to the above questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[beechill4]

Folks,

I want to use the same data files.

I am not using any of the enterprise features.

Joe

 

[SantaMufasa]

If you wish to use the same data files, to clone the database, then that is a bit tricky. Presuming that you have already installed the Oracle software, you must:

1) Ensure that you are using the same-flavoured operating system (i.e., Solaris to Solaris, or Windows to Windows). [If you are using Windows, you must ensure that you have run the appropriate "oradim" command to create the Oracle service on the target machine. Start the service on Windows.]

2) Copy all database files from the source machine to the target machine. Bring across all files that you would need to make the source database run: for example, parameter file, database data files, on-line redo log files, and control files.

3) Using SQL*Plus, attempt to start the cloned database. Address any startup errors that you may encounter.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[beechill4]

Thanks Dave,

I will report back on progress