I have installed Oracle-XE on my Ubuntu laptop and it was working at the beginning and then after I restart I noticed the database is not open. I believe I did shut down my laptop in an unexpected fashion causing this issue.

I don’t have any backup to restore. Below is the set of instructions I have tried so far.

Any comment/clue is much much appreciate it.

Regards Mike

mike@mike-Laptop:/home/oracle$   sqlplus sys as sysdba  SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 12 00:22:50 2018  Copyright (c) 1982, 2011, Oracle.  All rights reserved.  Enter password:  Connected to an idle instance.  SQL> startup  ORACLE instance started.  Total System Global Area 1068937216 bytes Fixed Size          2233344 bytes Variable Size         616565760 bytes Database Buffers      444596224 bytes Redo Buffers            5541888 bytes Database mounted. 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: '/u01/app/oracle/oradata/XE/system.dbf'   SQL> recover datafile 1;  ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done   SQL> recover database using backup controlfile;  ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: [kcvhvdf_1], [], [], [], [], [], [], [], [], [], [], []   SQL>