Error ORA-00313

[Former Member]

hi

i have installed SAP ECC 6.0 with oracle as Database.When i try to start the instance ,i got a Error

mesage saying DB startup failed.so i went through sqlplus and given the following commands.

SQL> startup

ORACLE instance started.

Total System Global Area 461373440 bytes

Fixed Size 2071928 bytes

Variable Size 239075976 bytes

Database Buffers 213909504 bytes

Redo Buffers 6316032 bytes

Database mounted.

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

ORA-00312: online log 1 thread 1: '/oracle/QAS/origlogA/log_g11m1.dbf'

ORA-00312: online log 1 thread 1: '/oracle/QAS/mirrlogA/log_g11m2.dbf'

i hope u guys can crack this error.

Regards

Ganesh Reddy

[Former Member · Accepted solution]

Hi Ganesh

For some reason Oracle cannot read or locate these two files that is why it is not able to start up.

ORA-00312: online log 1 thread 1: '/oracle/QAS/origlogA/log_g11m1.dbf'

ORA-00312: online log 1 thread 1: '/oracle/QAS/mirrlogA/log_g11m2.dbf'

Check that while installation you have provided the same drives for Origlog and Mirrlog.