Oracle Database Discussions

Hi

Oracle Developer seeks Oracle DBA !!

I am getting the above error on my personal edition of the 11g database - backups etc forget them - this is just a personal development environment.

I think it may have been caused by a power failure, whenever I try and connect I get


ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


So then I shutdown and startup

SQL> connect / as sysdba
Connected.
SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size 2176328 bytes
Variable Size 1157630648 bytes
Database Buffers 503316480 bytes
Redo Buffers 7098368 bytes
Database mounted.


Now I'm just guessing based on internet searches

SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR at line 1:
ORA-00279: change 14067912 generated at 10/10/2011 23:15:25 needed for thread 1
ORA-00289: suggestion :
C:\APP\USER\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_10_15\O1_MF_1_569_%U_.ARC
ORA-00280: change 14067912 for thread 1 is in sequence #569


SQL> alter database recover continue default;
alter database recover continue default
*
ERROR at line 1:
ORA-00308: cannot open archived log
'C:\APP\USER\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_10_15\O1_MF_1_569_%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.


SQL> alter database recover cancel;
alter database recover cancel
*
ERROR at line 1:
ORA-10879: error signaled in parallel recovery slave
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:\APP\USER\ORADATA\ORCL\SYSTEM01.DBF'


SQL> recover datafile 1;
ORA-00275: media recovery has already been started


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:\APP\USER\ORADATA\ORCL\SYSTEM01.DBF'



Would appreciate any pointers as to the above

- Is SYSTEM01.DBF busted?
- And if so (how) can it be fixed ?


Thanks in advance

Jon