I got ” ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956 ” error in Oracle database.
ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956
Details of error are as follows.
RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 12/02/2020 17:12:11 ORA-01119: error in creating database file '+DATA' ORA-17502: ksfdcre:4 Failed to create file +DATA ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15018: diskgroup cannot be created ORA-15001: diskgroup "DATA" does not exist or is not mounted RMAN-06956: create datafile failed; retry after removing from OS
RMAN-06956: create datafile failed; retry after removing from OS
The ORA-15018 ORA-15001 RMAN-06956 error is related with the permission issue.
Issue is related to permission issue, check and fix it .
The Grid home is owned by oinstall
ls -lrt /<oracle home>/bin/oracle -rwsr-s--x 1 oracle oinstall 327811823 Oct 2 16:50 /<oracle home>/bin/oracle
The ASMdisks would be owned by grid:asmadmin so if the database needs to access those disks then the oracle binaries have to be oracle:asmadmin.
Change the group to asmadmin :
chown oracle:asmadmin oracle
chgrp asmadmin /<oracle home>/bin/oracle ls -lrt /<oracle home>/bin/oracle -rwsr-s–x 1 oracle asmadmin 327811823 Oct 5 16:50 <oracle home>/bin/oracle
SET NEWNAME FOR DATAFILE
If this issue is not permission in your environment, then use SET NEWNAME command to specify path\location on the target server.
To solve this error, modify the restore DATAFILE command would be “SET NEWNAME FOR DATAFILE” followed by file number and the path where the file is to be restored.
To solve this error, use SET NEWNAME FOR DATAFILE command before restore database as follows
connect target /
run
{
allocate channel ch01 device type disk;
allocate channel ch02 device type disk;
allocate channel ch03 device type disk;
allocate channel ch04 device type disk;
allocate channel ch05 device type disk;
allocate channel ch06 device type disk;
allocate channel ch07 device type disk;
allocate channel ch08 device type disk;
SET NEWNAME FOR DATAFILE 1 TO '+DATA/MSDBDR/DATAFILE/system.304.977575675';
SET NEWNAME FOR DATAFILE 2 TO '+DATA/MSDBDR/DATAFILE/sysaux.303.977575675';
SET NEWNAME FOR DATAFILE 3 TO '+DATA/MSDBDR/DATAFILE/undotbs1.302.977575677';
SET NEWNAME FOR DATAFILE 4 TO '+DATA/MSDBDR/DATAFILE/undotbs2.300.977575685';
SET NEWNAME FOR DATAFILE 5 TO '+DATA/MSDBDR/DATAFILE/undotbs3.299.977575685';
SET NEWNAME FOR DATAFILE 6 TO '+DATA/MSDBDR/DATAFILE/undotbs4.298.977575687';
SET NEWNAME FOR DATAFILE 7 TO '+DATA/MSDBDR/DATAFILE/undotbs5.297.977575687';
SET NEWNAME FOR DATAFILE 8 TO '+DATA/MSDBDR/DATAFILE/undotbs6.296.977575687';
SET NEWNAME FOR DATAFILE 9 TO '+DATA/MSDBDR/DATAFILE/undotbs7.295.977575689';
SET NEWNAME FOR DATAFILE 10 TO '+DATA/MSDBDR/DATAFILE/undotbs8.294.977575689';
SET NEWNAME FOR DATAFILE 11 TO '+DATA/MSDBDR/DATAFILE/users.293.977575689';
SET NEWNAME FOR DATAFILE 12 TO '+DATA/MSDBDR/DATAFILE/tdbaspace01.274.977578993';
RESTORE DATABASE;
switch datafile all;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
release channel ch08;
}
Do you want to learn more details about RMAN, then Click this Link and read the articles.
Do you want to learn Oracle Database for Beginners, then Click and read the following articles.
Oracle Database Tutorials for Beginners ( Junior Oracle DBA )