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.
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...
No comments:
Post a Comment