My Oracle Support Banner

Manual Completion of a Failed RMAN Duplicate FROM ACTIVE DATABASE (Doc ID 1602916.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 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

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