ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956

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 )

 

 750 views last month,  3 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

IT Tutorial