ORA-03113 or ORA1403

RMAN Duplicate or Restore fails with ORA-3113 and ORA1403 on new Host [ID 1096687.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.1 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

When trying to duplicate or restore a Database to a different Host, the RMAN RESTORE, DUPLICATE (pre 11.2.0.x) or CROSSCHECK Command can fail with


ORA-03113: end-of-file on communication channel
ORA-01403: no data found
ORA-01403: no data found

Changes

The Source Target Database is using ASM where the new Database on the other Host does not use ASM and ASM is even not installed on this new Host. RMAN Backups have been stored in ASM on the Source System.

Cause

If you restore the Controlfile from a Backup of the Source Database, it contains Information about Backupsets in ASM. Since RMAN cannot connect to any ASM Instance on the new Host, the Commands fail with

ORA-03113: end-of-file on communication channel
ORA-01403: no data found

These Errors even occur if you copy the Backup Pieces from ASM to Filesystem, transfer them to the Destination Host and catalog them in the new restored Controlfile.

Solution

You have to uncatalog all Backup Pieces registered with ASM from the new Controlfile before you actually restore or duplicate the Database. You can follow this Procedure to do that:

1. Restore the Controlfile and mount the new Database

2. Get a list of all cataloged Backups to get the Backup Pieces and corresponding Keys for step 3.

RMAN> list backup;

3. Uncatalog all Backup Pieces registered with an ASM-Location

RMAN> change backuppiece <Key> uncatalog;

4. Catalog all Backup Pieces you have copied over from the Source Database


RMAN> catalog backupiece '<Filename>';

or

RMAN> catalog start with '<directory where the backups are located>';

5. Restore the Database

RMAN> restore database...