Labels

Saturday, 5 August 2017

How to fix data file (ORA-01110: data file 4: '/disk1/dev/data/users01.dbf') missing issue in oracle.

I got the below error when I am trying to start up the data base in oracle 11g.

ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/disk1/dev/data/users01.dbf'

Error screen : 

















In order to fix the above error. We just need to copy the users01.dbf file from missing location.

Resolution :

In my case the backup file is located in disk2/coldbackup so I have copied this file to the target location i.e /disk1/dev/data/




No comments:

Post a Comment