Tuesday 17 October 2017

ORA-01110 ORA-01180: cannot create datafile | Oracle Database

 ORA-01110 & ORA-01180: can not create datafile in Oracle Database

ORA-01110 ORA-01180 Oracle Errors


Ok, so this one's interesting..

This happened with me while creating a Oracle Standby where I was replicating the Primary Database to Standby with the RMAN Backup. I copied the backup pieces to the Standby Server after I had finished all the prerequisites of Installing Oracle Database in UNIX/LINUX Systems (IBM AIX 64-bit in my case). After that instance was brought to nomount state with primary database PFILE once it was made sure that all the necessary changes for the Standby Database in the PFILE were done. Controlfile backup for Standby Database was restored and the database was brought more further i.e. to mount state. Only restore was left so I ran the restore command and this happened,

Starting restore at 13-OCT-17
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8

creating datafile file number=1 name=/data/dcstndby/system.279.915710127
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/13/2017 07:08:04
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data/dcstndby/system.279.915710127'

RMAN>

Resolution:

I am mentioning below 3 main scenarios which majorly brings these errors,

1. There's something wrong with the database incarnation. Either you need to fix your oracle database's incarnation or the issue might be related to the parameter file that you are using to bring the instance up. To understand this, please follow Oracle Docs - Doc IDs 1573040.1 and Doc ID 727655.1

2. The problem can be related to privilege issues majorly in UNIX/LINUX systems. Make sure you are not making such kind of mistake.

3. RMAN doesn't know of the database backups. This was my case where I forgot to catalog the backup files in Oracle RMAN repository from where I needed to perform the restore.

I hope this helps !!

1 comment: