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 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 7.3.4.5 to 11.2.0.3 [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.

Purpose

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.