Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2008
    Posts
    18

    Unanswered: Getting Error ORA:01110 while starting Oracle

    Hi,

    I have Oracle 7.3 installed on SCO unix Open Server 5.0.
    While starting Oracle it is giving "ORA:01110 File 30 needs media recovery"
    Then it shows "ORA:01113 File30: "/ora/data/users02.dbf"

    Here I am using 4 dbf files for my tablespace. From that it is giving error for 1. Becauese of this Oracle starts it mounts Database but it doesnt open and cant run any sql query.

    Please help me. I have Backup of DB in ".dmp" format, but how can I import a single file from .dmp file ?

    Please help.
    Thanks
    Neel

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have Backup of DB in ".dmp" format,
    A "dmp" file created by export is NOT a backup file.


    >but how can I import a single file from .dmp file ?
    You can NOT do so, because import requires the database to be open & it won't open.

    When did you take the last cold backup?
    Was the database opened in archived mode?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2008
    Posts
    18
    I have taken backup the day before it stopped started working. But I took backup like following way:

    1. Export to .dmp file
    2. Write that file on Tape Drive.

    Now I have that .dmp file on Tape.

    I am not aware of how to start Oracle in Archive mode.

    Note: User has completed work with Oracle they just want to read the data from the Database as the Data is old.

    Thanks
    Neel

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    The first thing you should do now is shutdown Oracle & take a complete
    OS backup of the system.

    I believe you only alternative is to create a new, empty database & import the dump file into it.

    I suspect that the hardware is failing; which is how/why the file got corrupted.

    Good Luck, because you'll need it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2008
    Posts
    18
    I resolved this issue by following way:

    # svrmgrl
    SVRMGR>connect internal

    SVRMGR>startup
    THen it gave same error. So DB got mounted but not opened.

    SVRMGR>RECOVER

    Media Recovery Done.

    THen I restarted Oracle and it worked. This time it didnt show the error.

    Is this ok? or anything else I should look for ?
    How did it media recovery?

    Thanks
    Neel

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What that means is that the information that the database needed was in the redo logs. You were very lucky.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •