-
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?
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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
anandkl
-
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.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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
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
-
-
Hi dear,
If u cant access metalink, just email me 100 pesos and i print it for you
Dont paste Copyrighted things here
Last edited by pando; 03-09-2005 at 04:01 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|