How to Use Rman to Skip Recovery of Offline datafiles
Last updated on MARCH 19, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
Skip tablepsace would skip all files of tablespace.
Recreate controlfile without problematic datafile catalog all the backupieces and do the recovery.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms