How to retrieve OEE database log

Hi, wondering how to start trouble-shooting the OEE database which is suspiciously in error ?
Let's say you have checked the application level and could not find any error. Then let 's turn to OS level Eg, event viewer for the log. And then next will be DB log. 1st will be alert_xxx.log which is normally located at db server \app\oracle\diag\rdbms\orcl\orcl\trace.

alert_orcl.log

Thu Jun 26 16:33:29 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.

xxxxxxxxxxxx

xxxxxxxxxxxxxxx

Errors in file F:\APP\diag\rdbms\orcl\orcl\trace\orcl_ora_3628.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: 'F:\APP\ORADATA\ORCL\REDO01.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.

Clearing online redo logfile 1 F:\APP\ORADATA\ORCL\REDO01.LOG

Clearing online log 1 of thread 1 sequence number 0

Errors in file F:\APP\diag\rdbms\orcl\orcl\trace\orcl_ora_3628.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: 'F:\APP\ORADATA\ORCL\REDO01.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.

----------------- example of the log ------------------

With this, look up the error code Eg, ORA-00313 and look into \APP\diag\rdbms\orcl\orcl\trace\orcl_ora_3628.trc  for detail. You should be able to find the culprit here.

Hope that helps..