Re: Renaming & Cloning a DB

You can rename a database by backing up the control file to the trace directory, shutting
down the database and deleting your old control files.

Edit the backed up controlfile and change the line:

CREATE CONTROLFILE REUSE DATABASE "dbname" NORESETLOGS (NO)ARCHIVELOG

to

CREATE CONTROLFILE SET DATABASE "newdbname" RESETLOGS (NO)ARCHIVELOG

Your database will now be renamed.

In order to clone a database, and provided you are staying with the same operating system and database
version, you can backup the controlfile, shutdown the database, copy all of the database files (including
redo log file) to a new host/directory, and then execute the backed up controlfile to recreate the database.

Hope that helps

Graham

maju_bellamin_at_my-deja.com wrote:

> Hi,
>
> I 've two questions
>
> 1. How can I rename a DB?
> 2. How can I clone a DB?
>
> Send answers to maju_bellamin_at_hotmail.com
>
> Thanks
>
> Maju Bellamin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 17 2000 - 00:00:00 CDT