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>