My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2019

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.

Purpose

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

Scope

This article is meant for database administrators and backup and recovery
specialists tasked with the ongoing creation and administration of clone
databases.

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

Details

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
Purpose
Scope
Details
 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
References

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