Another oracle error #ORA01219 – restore in online mode

If your database crashed in a active state, you might get an #ORA01219 error.

Tip If you are new to oracle network testing, I recommend you to consult this document: http://docs.oracle.com/cd/E14072_01/network.112/e10836/connect.htm#i429243

This might look like a nightmare, but you can fix the corrupt data pretty easy, you need a oracle console, like SQLPLUS or PLSQL or any tool you like working with and see wich datafiles need to be recovered by typing:

Start by the following query:

ora1

ora 3

After trying to open the database, I got the following messageora4


If you see this error, type

and the datafile that needs recovery appearsora5

Repeat the 4 steps below for all the datafiles that need recovery and you have saved the day! Yeeh!

More corrupt files? check out my previous blog: http://www.thebuttonfactory.nl/?p=1256