My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.5 to 11.2.0.3 [Release 7.3.4 to 11.2]
Oracle Database - Standard Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 13-Jun-2012***

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.

Scope

For DBAs.

Details

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
Purpose
Scope
Details
 Overview
 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
 7. Check REMOTE_LOGIN_PASSWORDFILE Parameter
 8. Execute the 'CREATE CONTROLFILE' Command for the Copied Database
 9. Make a Full Cold Backup of the Copied Database
References

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