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 18.104.22.168 to 10.2.0.4 [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