Wrong Status: RMAN Advice Failure shows OFFLINE for Dropped Datafile (Doc ID 1595089.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

(DRA - Data Recovery Advisor)

DRA LIST FAilure shows OFFLINE for Dropped Datafile.

Mon Feb 04 15:58:46 2013
DROP TABLESPACE "MAX_BKUP_DDATA" INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS
Deleted file /p02/oradata/mxp/mxp_max_bkup_ddata_01.dbf
Deleted file /p02/oradata/mxp/mxp_max_bkup_ddata_02.dbf
Deleted file /p02/oradata/mxp/mxp_max_bkup_ddata_03.dbf
Deleted file /p02/oradata/mxp/mxp_max_bkup_ddata_04.dbf
Deleted file /p02/oradata/mxp/mxp_max_bkup_ddata_05.dbf
Completed: DROP TABLESPACE "MAX_BKUP_DDATA" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
Mon Feb 04 16:41:19 2013


RMAN> list failure;
2> advise failure;
3> exit
using target database control file instead of recovery catalog
List of Database Failures
=========================

Failure ID Priority Status    Time Detected       Summary
---------- -------- --------- ------------------- -------
5253       HIGH     OPEN      2013-02-04 15:58:21 One or more non-system datafiles are offline

List of Database Failures
=========================

Failure ID Priority Status    Time Detected       Summary
---------- -------- --------- ------------------- -------
5253       HIGH     OPEN      2013-02-04 15:58:21 One or more non-system datafiles are offline

analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=593 device type=DISK
analyzing automatic repair options complete

Mandatory Manual Actions
========================
1. Please contact Oracle Support Services to resolve failure 5256: Datafile 122: '/p02/oradata/mxp/mxp_max_bkup_ddata_01.dbf' is offline <---FILE Status is OFFLINE
2. Please contact Oracle Support Services to resolve failure 5262: Datafile 123: '/p02/oradata/mxp/mxp_max_bkup_ddata_02.dbf' is offline
3. Please contact Oracle Support Services to resolve failure 5268: Datafile 124: '/p02/oradata/mxp/mxp_max_bkup_ddata_03.dbf' is offline
4. Please contact Oracle Support Services to resolve failure 5274: Datafile 125: '/p02/oradata/mxp/mxp_max_bkup_ddata_04.dbf' is offline
5. Please contact Oracle Support Services to resolve failure 5280: Datafile 126: '/p02/oradata/mxp/mxp_max_bkup_ddata_05.dbf' is offline


Cause

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