This content has been marked as final. Show 3 replies
First, Oracle software is not certified/supported on any Home versions of Windows - http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABHICJH1 person found this helpful
Since you are using an unsupported version of the software, things may or may not work as advertised.
Second, if all you did was to reboot the laptop with the database up and running (and nothing else), then when you restart the laptop and restart the database, the database will recover automatically without you even knowing about it. The fact that you are running into this error indicates you are not telling us the whole story ;-)
Thanks for your input. This is the true story. See log from screen. Please let me know how to fix this.
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1388352 bytes
Variable Size 801112256 bytes
Database Buffers 264241152 bytes
Redo Buffers 4591616 bytes
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-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'
What you have described is not normal - pl post the last 300 lines from the database alert log file. Is the database in archivelog mode ? Do you have any backups ?
Re: Flash Recovery ->SYSTEM.DBF
location of alert log in 11g