Hello.
Suddenly my Oracle XE 11g database refuses to start.
I tried to run 'connect' as 'system' user in SQL Command line, it shows:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Testing datasources in weblogic domain administration console reports the same error.
Then I performed some steps following some forum searches and tips which I can't remember now (foolish thing )
New errors lead me to recovering database using:
SQL>recover database using backup controlfile until cancel
It shows:
ORA-00279: change 2708486 generated at 11/11/2013 22:33:45 needed for thread 1
ORA-00289: suggestion :
C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2013_11_12\O1_MF_1_101_%U_.ARC
ORA-00280: change 2708486 for thread 1 is in sequence #101
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2013_11_12\O1_MF_1_101_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00308: cannot open archived log
'C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2013_11_12\O1_MF_1_101_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'
Then I ran
SQL>alter database open resetlogs;
result is:
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'
Now I realize that maybe I made some stupid mistake when performed commands without knowing the possible result, but I am not well famiiliar with Oracle database, I used it in conjunction with Webcenter Content and Webcenter Sites, to learn Oracle products. Probably it became broken because of force domain shutdown or something like this.
What should I do now to make recovery 'consistent'?
Thanks in advance.