Restore Database Fails on ASM with error ORA-19504 ORA-17502 ORA-15001 ORA-15040: diskgroup is incomplete

(Doc ID 2319465.1)

Last updated on OCTOBER 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

 Restore database on ASM fails with

 

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/TEST1/DATAFILE/system.280.938093005
channel ORA_DISK_1: restoring datafile 00002 to +DATA/TEST1/DATAFILE/sysaux.274.938092969
channel ORA_DISK_1: restoring datafile 00003 to +DATA/TEST1/DATAFILE/undotbs1.273.938092969
channel ORA_DISK_1: restoring datafile 00004 to +DATA/TEST1/DATAFILE/users.279.938093029
channel ORA_DISK_1: restoring datafile 00005 to +DATA/mgmt_depot.dbf
channel ORA_DISK_1: restoring datafile 00006 to +DATA/mgmt.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DATA/mgmt_ad4j.dbf
channel ORA_DISK_1: reading from backup piece /u01/TEST1/DB_FULL_REVPROEM_20171001_956268007_15247
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /u01/TEST1/DB_FULL_REVPROEM_20171001_956268007_15247
ORA-19504: failed to create file "+DATA/mgmt.dbf"
ORA-17502: ksfdcre:3 Failed to create file +DATA/mgmt.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete

 

SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> select name, state from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
RECO MOUNTED
DATA MOUNTED

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