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/
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