Friday, November 9, 2012

Clonning the database with connecting to Primary database.

Here I'll show you how to Clone the Primary Database from one server to another server.

I've a Primary database "prim" which is running over one host and on second host, which is for Clone Database "stby", I have already installed Oracle Binaries.

Below are the Steps which I have followed to clone the Primary Database, also I have attached the configuration files whenever and wherever it needed.

1.Configured the Listener and TNS files on both the servers.
2.Created Oracle Password file.
3.Took the Primary Database full backup including its archivelogs.
4.Created the directories over Clone Database server which is identical to Primary Database server like for audit, dbs, network, backup directory and its sub-directories viz., autobackup, backupset, archivelog etc.
5.Copied all the backups and Oracle Physical files to the Clone DB server.
6.Started the Clone Database in nomount mode with pfile.
7.From Primary Database server, I have connected the Auxiliary Database(Clone DB).
8.With RMAN prompt, I run the duplicate command to clone the Prim DB to another host.

I've attached Listener and TNS files for both Prim and Clone Database.

@ prim

listener.ora
tnsnames.ora

@ stby

listener.ora
tnsnames.ora






























@stby

Configure the copied pfile for clone database.

Here I have mentioned the "db_unque_name" and removed the parameters for "controlfile" and "memory_target".

Once defined the pfile for clone database, open the clone database "stby" in nomount mode.


@prim

From Primary Database server, connect the clone database and then start the cloning process.































Now we can see that Cloning of the primary Database has been completed.

 Check the status of the clone database.












We can see that Cloned Database is created and its status is UP.

In another session, I'll show you how to create standby database.

No comments:

Post a Comment