Resolved Issue of ORA:01110 File needs media recovery

I have setup Oracle7.3 on SCO Openserver 5.0.

While starting Oracle I was getting error “ORA:01110 File 30 needs media recovery.

I resolved this by following way:

1. Logged in as oracle user.
2. Gave below commands:

# 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.
This means it recovered data from “redo.log”. I was lucky.

Cheers

Neelesh Gurjar has written 122 articles

Leave a Reply