Database Backup and Recovery (MOSC)

MOSC Banner

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center