How to Make a Copy of a Database on the Same Unix Machine
(Doc ID 18070.1)
Last updated on JANUARY 30, 2022
Oracle Database - Standard Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2] Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!