ora-113 file fileName needs media recovery

[helloworld2]

Hi, all
I'm using oracle 9i with Windows XP. My problem is whenever I want to log on using SQL PLUS I got the error:
ORA-01033 ORACLE initialization or shutdown in progress. I tried to connect as sysdba to try the database opened. But when I try to open the database I got the error: ORA-1113 file 5 needs media recovery ORA-01110 datafile 5 : 'C:\oracle\oradata\dbName\EXAMPLE01.DBF';

Can anybody help me, please?
I don't have any backup 'cause I installed oracle in this week and I'm not to loose any data but I don't want to uninstall it and install it again.

Regards,
Neg.

 

[SantaMufasa]

What happens if you do the following:

sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup mount
SQL> recover database
(if the result is "recovery complete", then...)
SQL> alter database open;

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]