Getting Error ORA:01110 while starting Oracle

neel.gurjar · #1 (**permalink**) 07-04-08, 15:52

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

anacedent · #2 (**permalink**) 07-04-08, 16:12

>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?

neel.gurjar · #3 (**permalink**) 07-04-08, 16:50

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

anacedent · #4 (**permalink**) 07-04-08, 16:55

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.

neel.gurjar · #5 (**permalink**) 07-07-08, 12:50

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

beilstwh · #6 (**permalink**) 07-08-08, 09:50

What that means is that the information that the database needed was in the redo logs. You were very lucky.