Oracle Database Discussions

Hi...

Again, I am creating methods for the management this month. My task is to present all types of database cloning / migration.... I need at least 5

So far I have successfully done the following...

1. RMAN clone database
- same database name, same structure
- same database name, different structure
- different database name, same structure
- different database name, different structure
(done with all of these)

2. Use traditional Export / Import process
- full exp and full imp
- per schema exp and per schema imp
(done with all of these)

3. Use Datapump (EXPDP and IMPDP)
- full exp and full imp
- per schema exp and per schema imp
(done with all of these)

4. Tablespace Migration
- from same server
- to different server with different structure

5. Database cloning using DBCA (Database Template)
- done with creating database from template in the same server

My BIG problem is...i do not know how to do this on another server...my current scenario is:

Source Database: PROD (Oracle 10.2.0.5)
Hostname: serv-prod.example.com
- I created database template name PROD02 from the existing PROD database using DBCA (i chose to use OMF option so in case I will clone it in a server with different structure)
- I had the .dfb and .ctl files in my chosen location
- I managed to restore this on the same server (serv-prod.example.com)


I have another server: prod02-serv.example.com with the same database version 10.2.0.5 and with different structure.
I SCP'ed all my .dfb and .ctl files to this remote location.

How can I use this template to create my database PROD02? When I run DBCA, the template is not there... :(

Any help please.... thanks a lot...