My Oracle Support Banner

How to Use Rman to Skip Recovery of Offline datafiles (Doc ID 2375339.1)

Last updated on MARCH 13, 2019

Applies to:

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

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


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