Unable to Open Database after Windows OS Crash
Database: 11.2.0.2.0 (XE)
unable to Open database after restoring the OS, I used the steps below to recover my database the control files are not available I had to create a new one.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 633340848 bytes
Database Buffers 427819008 bytes
Redo Buffers 5517312 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'