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]

i already see this problem for resolved i have to do this:

"ALTER DATABASE RECOVER database until cancel;

alter database open resetlogs

alter database backup controlfile to trace

alter database clear logfile '/oracle/SID/origlogA/log_g11m1.dbf'"