exporting db to dump file, ORA-01157 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: exporting db to dump file, ORA-01157 error

  1. #1
    Join Date
    Mar 2005
    Posts
    4

    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

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

  6. #6
    Join Date
    Mar 2005
    Posts
    4

    Talking

    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

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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
  •  


Click Here to Expand Forum to Full Width