April 26, 2013
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:
Alter database open select * from v$datafile;
--alter database open
Repeat the 4 steps below for all the datafiles that need recovery and you have saved the day! Yeeh!
--Select * from v$datafile; --recover datafile ‘E:\ORADATA\DAT02EBMSDATA.DBF’; --Select * from v$log; --Alter database recover datafile 11;
More corrupt files? check out my previous blog: http://www.thebuttonfactory.nl/?p=1256