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]

Dear Ganesh,

What the error shows that the redologfiles r multiplexed and for some reason the oracle cant read the redo log files in Group 1.

ALTER DATABASE ADD LOGFILE GROUP 6

('....ORACLE\QAS\ORILOGA\LOG_G11M6.ORA','...ORACLE\QAS\ORILOGA\LOG_G11M7.ORA') SIZE 1M;

NOW SHUTDOWN ORACLE & RESTARTIT.

EXECUTE:

ALTER DATABASE DROP LOGFILE GROUP 1;

IT MAY SHOW AN ERROR THAT

LOG 1 IS CURRENT LOG FOR THREAD 1 CANNOT DROP.

IF THIS ERROR SHOWS EXECUTE

ALTER SYSTEM SWITCH LOGFILE;

THIS MAY SHOW AN ERROR DATABASE NOT OPEN

IF SO EXECUTE

ALTER DATABASE OPEN;

WHEN THE DATABASE IS OPEN

EXECUTE

ALTER SYSTEM SWITCH LOGFILE;

IF IT IS SWITCHED

DROP THE LOGFILE GROUP1 BY EXECUTING:

ALTER DATABASE DROP LOGFILE GROUP 1;

IF THE DATABASE ALTERED MSG COMES SHUTDOWN AND RESTART.

WE ADDED A LOGFILE GROUP COZ ATLEAST 2 LOGFILE GROUPS ARE REQUIRED THEN WE DROPPED THE GROUP1.

This has to help and pl dont forget to award a point.

Regards

[Former Member]

Hi GAnesh,

Is your prob resolved?