Help! I can't open the database, I get the ora-03113 error message
Here's my trace file
Tue Oct 08 22:37:15 2013
ARC3 started with pid=34, OS id=3016
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Errors in file e:\app\ABIGAIL\diag\rdbms\orcl\orcl\trace\orcl_lgwr_1952.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
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-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1A.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Errors in file e:\app\ABIGAIL\diag\rdbms\orcl\orcl\trace\orcl_lgwr_1952.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
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-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1A.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Errors in file e:\app\ABIGAIL\diag\rdbms\orcl\orcl\trace\orcl_ora_2908.trc:
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1A.LOG'
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
USER (ospid: 2908): terminating the instance due to error 313
Instance terminated by USER, pid = 2908
Trace file e:\app\ABIGAIL\diag\rdbms\orcl\orcl\trace\orcl_ora_2908.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x0x00000000
Memory (Avail/Total): Ph:276M/1791M, Ph+PgF:1116M/3685M, VA:1166M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 31
Windows thread id: 2908, image: ORACLE.EXE (SHAD)
*** 2013-10-08 22:37:15.453
*** SESSION ID:(125.5) 2013-10-08 22:37:15.453
*** CLIENT ID:() 2013-10-08 22:37:15.453
*** SERVICE NAME:() 2013-10-08 22:37:15.453
*** MODULE NAME:(sqlplus.exe) 2013-10-08 22:37:15.453
*** ACTION NAME:() 2013-10-08 22:37:15.453
DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1A.LOG'
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1A.LOG'
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1A.LOG'
ORA-00312: online log 1 thread 1: 'E:\APP\ABIGAIL\ORADATA\ORCL\REDO1B'
*** 2013-10-08 22:37:15.484
USER (ospid: 2908): terminating the instance due to error 313
I realize I don't have redo1a.log and redo1b .. can I just simply recreate those files at the OS level?
I'm using winxp pro, oracle 11gR2
Thanks guys!