Manual Completion of a Failed RMAN Duplicate FROM ACTIVE DATABASE
(Doc ID 1602916.1)
Last updated on APRIL 23, 2021
Applies to: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
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
The purpose of this note is to provide an explanation of incomplete
duplication FROM ACTIVE DATABASE, its consequences, and how to resolve related problems.
Another document handling a look-a-like issue, for Backup based duplication, is :
<Note 360962.1> Manual Completion of a Failed RMAN backup-based Duplicate
This article is meant for database administrators and backup and recovery
specialists tasked with the ongoing creation and administration of clone
All manual completion steps from failure in phase 1 and 2 have been tested at 11g R2. They are NOT applicable for Oracle 10g, 9i and 8i as the FROM ACTIVE DATABASE-clause is not available
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
|1. Manual Completion of Phase 1 : Create SPFILE and restore controlfile|
|2. Manual Completion of Phase 2: Restore datafiles and archives |
|3. Manual Completion of Phase 3:Recovery|
|4. Manual Completion of Phase 4: Controlfile Recovery|
|5. Manual Completion of Phase 5: Open Resetlogs|
|6. Final Actions|