Dears,
We've have an Oracle 9i database running on Windows. Last week there was a power shutdown and the database was down too.
After the power came, when we tried to start the database we couldn't and it's giving below error: We're in Mount state now.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'E:\ORACLE\ORADATA\ABC\TOOLS01.DBF'
Unfortunately, we have no valid backups and it's our PRODUCTION database.
Can someone help me on this to resolve the issue.
Thanks.