How to Use Rman to Skip Recovery of Offline datafiles
(Doc ID 2375339.1)
Last updated on AUGUST 14, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle 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
Information in this document applies to any platform.
Goal
This Document is applicable for the following Conditions.
You have a database which has one or more datafile which are offline and cannot be recovery since the archivelog need for the same no longer exist.
When you restore and recovery such database using rman,Rman recovery would ask for archivelog required for the offline file as Currently Rman doesnot have any option to Just skip offline files during
recovery.
Skip tablepsace would skip all files of tablespace.
or
Recreate controlfile without problematic datafile catalog all the backupieces and do the recovery.
or
Skip the tablespace ,do the restore/recovery.
This Document gives details about the Bug fix which allows rman to skip offline datafiles using SKIP OFFLINE option during recovery.
Solution
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
Goal |
Solution |
References |