My Oracle Support Banner

How to clone/duplicate a database with added datafile with no backup. (Doc ID 292947.1)

Last updated on DECEMBER 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Information in this document applies to any platform.


How can I clone/duplicate a database and change it's name if a datafile backup is missing. Archivelog files are available for recreating the datafile using 'alter database create datafile'.

I.e., a datafile was added to the database, but not yet backed up. Archive files are available to recreate this datafile. How can a clone/duplicate database be created in this scenario?

Issues to consider:

1. The RMAN duplicate command will want to create a new controlfile. However, the new datafile will not be added to the controlfile.
2. If a new controlfile is created with a database name change, the datafile cannot be added after the fact.
3. You cannot create a datafile (using alter database) if that datafile is not listed in the controlfile.


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

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