My Oracle Support Banner

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

Last updated on MARCH 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
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 Database Cloud Exadata Service - Version N/A and later
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 "<TABLESPACE NAME>" INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS
Deleted file /<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_01.dbf
Deleted file /<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_02.dbf
Deleted file /<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_03.dbf
Deleted file /<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_04.dbf
Deleted file /<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_05.dbf
Completed: DROP TABLESPACE "<TABLESPACE_NAME>" 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: '/<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_01.dbf' is offline <---FILE Status is OFFLINE
2. Please contact Oracle Support Services to resolve failure 5262: Datafile 123: '/<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_02.dbf' is offline
3. Please contact Oracle Support Services to resolve failure 5268: Datafile 124: '/<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_03.dbf' is offline
4. Please contact Oracle Support Services to resolve failure 5274: Datafile 125: '/<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_04.dbf' is offline
5. Please contact Oracle Support Services to resolve failure 5280: Datafile 126: '/<oracle base>/oradata/<db name>/<db name>_<TABLESPACE NAME>_05.dbf' is offline


Cause

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
Symptoms
Cause
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.