database cloning on same unix box

[jlakhani]

hello
i want to clone the database on u01 to u02 except the name of the instance and lissterner name will
be different..please help

[kamath_g]

Why do you want to have a diff listener name ?

Well, the procedure is as follows.

Issue the command 'Alter database backup controlfile to trace; ' to get the control file
binary.

Shutdown your database

Move all files across to u02

Make sure all the paths are valid such as udump,ctl files,bdump etc.

Export your SID to your new database.

Make sure you edit the control file.

You have to use create controlfile set database with resetlogs option.

Connect internal from svrmgrl

Use startup nomount

run the recreate_controlfile.sql script to create the controlfile from the prompt.

then your database will be mounted.

Then recover the database using command

Recover database using backup controlfle;

Then open the database by using the command

Alter database open Resetlogs;

Shutdown and take a backup.

Then mount normally.

Hope this helps.