Re: How to copy an existing database

On UNIX:

In your current db, issue the ALTER DATABASE BACKUP CONTROL FILE TO TRACE command to give you a trace file that will give you the command to recreate new control files.

Shut down your current db.

>>>>PERFORM A FULL COLD BACKUP TO BE ON THE SAFE SIDE<<<<

Copy all your databases files to the new destination.

Create new copies of initSID.ora and configSID.ora for your new db SID in ORACLE_HOME/dbs (or whereever they are on your platform). Alter the init files to point to your new directories, especially the location of the new control files you are about to create.

Update the control file create script to have:

• a new SID after the "CREATE CONTROLFILE REUSE DATABASE"
• make sure you have "RESETLOGS" the use new redo logs.
• alter all the file definitions to point to the new location you copied your db to.

Run it through svrmgrl.

MotoX.

Frank Calfo wrote in message <01bda500$d0bd6ca0$e4010180_at_frank>...
>I've seen a document describing this process but can't seem to find it
>again.
>Can you tell me the steps on how to create a new instance as an exact copy
>of an existing one via copying/renaming the datafiles ?
>
Received on Thu Jul 02 1998 - 02:45:09 CDT