How to Use Rman to Skip Recovery of Offline datafiles

(Doc ID 2375339.1)

Last updated on MARCH 19, 2018

Applies to:

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

 

Workaround in thse case would be to take the problematic   datafile offline drop from sqlplus and continue with the recovery of database from sqlplus after after restoring the required archivelogs from Rman
 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms