My Oracle Support Banner

How to Make a Copy of a Database on the Same Unix Machine (Doc ID 18070.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Standard Edition - Version to [Release 11.2]
Oracle Database - Enterprise Edition - Version to [Release 7.3.4 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.


The following document deals with creating a copy of a database on the same unix machine. A database might need to be copied in order to duplicate the production system, for example for testing purposes. It is recommended that the reader refer also to the following documentation:

Oracle 7, 8, 8i, 9i, 10g, 11g Server Administrators Guide Performing full backups: Chapter 18 page 18-7 (note: chapters may vary between versions)

NOTE:  If you intend to use RMAN with a recovery catalog for the newly copied database, please use caution. If RMAN already has a database registered in the recovery catalog with the same DBID as the copied database, you can introduce a recovery catalog inconsistency. If you plan to register the copied database and you are not sure how to proceed, please open a new service request for the Recovery Manager support team and mention in the new service request this comment in this document.


For DBAs.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Obtain Database Information from ControlFile
 2. Identify Files to Backup/Copy
 3. Backup Existing Database
 4. Make a Copy of the Database
 5. Set Up Parameter Files for the Copied Database.
 6. Prepare the 'CREATE CONTROLFILE COMMAND' for the Copied Database
 8. Execute the 'CREATE CONTROLFILE' Command for the Copied Database
 9. Make a Full Cold Backup of the Copied Database

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.