• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 713
  • Last Modified:

Ora8i: Restore datafile

Good day All!
I have problems with restore of datafile.
At opening bases there is a message:
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/odb5/TRM/tools_01.dbf '

my actions:
SVRMGR > alter database datafile '/odb5/TRM/tools_01.dbf ' offline;
Statement processed.
SVRMGR > alter database open;
Statement processed.
SVRMGR> host
[oracle@trm odb2]$ cp /backup/odb5/TRM/tools_01.dbf /odb5/TRM/tools_01.dbf
[oracle@trm odb2]$ exit
SVRMGR > recover automatic datafile /odb5/TRM/tools_01.dbf ';
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/odb5/TRM/tools_01.dbf'

Where I was mistaken? Help me!!!
Server: Oracle 8i, Archivelog mode

BR, MaksPro.
1 Solution
cp /backup/odb5/TRM/tools_01.dbf /odb5/TRM/tools_01.dbf

Did your file copy correct ? I mean within directory(/odb5/TRM/) or directory where you want it to be.


Check for the file permissions and ownership for the datafile.  The file should be read-writeable and owned by oracle:dba.

Also post the Oracle errors from your DBWR trace file.

- Ramesh
in addition to Allahabad and ramkb, check if there is a bad sector in disk.
MaksProAuthor Commented:
Thank all!
The problem is solved.

BR, MaksPro.
Mark GeerlingsDatabase AdministratorCommented:
Can you tell us how the problem was solved?  Also, if one of the suggestions here helped you solve the problem, then you should accept it as the answer.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now