exporting db to dump file, ORA-01157 error

Hello oh good men of DBASupport!!!

I am trying to make a dump file out of my database and have been encountering the error

. exporting tablespace definitions
EXP-00008: ORACLE error 1157 encountered
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/opt/oracle/oradata/orcl1/temp01.dbf'
EXP-00000: Export terminated unsuccessfully

The same error occurs when I try to load data using the "imp" command. Please help me out here. This is getting critical for my project.

Thanks in advance.
Chandra

What did Metalink have to say about it?

Hi,
Check the status of this file
select status from dba_data_file where file_name='FILE_NAME';

Also see if this files needs recovery.

select * from v$recover_file;
Also check the most recent tracefile generated. It would tell you exactly what would be the issue.

Try running dbverfiy on this datafile.

It could be that this particular datafile is corrupt.


regards
anandkl

Quote:

---

Originally posted by anandkl
Hi,
Check the status of this file
select status from dba_data_file where file_name='FILE_NAME';

Also see if this files needs recovery.

select * from v$recover_file;
Also check the most recent tracefile generated. It would tell you exactly what would be the issue.

Try running dbverfiy on this datafile.

It could be that this particular datafile is corrupt.


regards
anandkl

---

Anadkl,
Are you promoting laziness or are you just showing people that they can come here and expect answers without doing any research on thier own? If you notice the posters registration date you will see that they are fresh off the truck. My simple question about checking Metalink should of sent all kinds of warning bells off to the seasoned poster such as yourself, as the answer to the posters problem is here.

Hi,
I do agree with you. But there could also be people who have no idea what metalink is. But to be frank, the time i cliked on the submit button, you had already sent your response.

Will make sure this will no happen again.

regards
anandkl

Hi,

Point 1: I'm not a highly skilled Oracle user. I'm in QA and I am responsible to set up another test environment. I don't have a DBA to work for me on this, so I have to do all of this myself. And I have had this issue for 3 days now, couldn't find a solution. And Metalink needs a license agreement and so on, the information of which I don't have right now.

Point 2: If you think you have given me too much information, what you have given has not gotten into my head. You'll have to be a bit more specific. I'd really like to have a bit more information!

Thanks a lot for understanding my situation.

Chandra

:rolleyes: :rolleyes: :rolleyes:

Hi dear,

If u cant access metalink, just email me 100 pesos and i print it for you :D

Dont paste Copyrighted things here