Cloning a database is normally done with the following sequence:
This is all quite straightforward even if you have to rename the database, and any of the files in the database. The secret is in step (2). On the source database, you can run SQL> alter database backup controlfile to trace at which point you will get a full "create controlfile" command dumped out to the user_dump_dest directory. It will look something like CREATE CONTROLFILE REUSE DATABASE "SOURCEDB" NORESETLOGS ARCHIVELOG For cloning this database, you will alter
For each file listed under the DATAFILE clause, if you will be renaming the file as part of the cloning process, then you simply update the file name to the new name in the CREATE CONTROLFILE command. |