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 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]Information in this document applies to any platform.
Goal
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.
Solution
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
Goal |
Solution |