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]

Ganesh,

See what you have at present

select group#, member from v$logfile;Check physically all files are present in the location.

Check How many groups u have select group#, member from v$logfile;

If u have more than 2 groups and the missing ones are from non active group u can drop th esame.let me know

i hope u have more than 2 groups and write perm to '/oracle/QAS/origlogA/'

u r missing members from group1 check physically

To switch u can issue alter system switch logfile;

Let me know if u need more help reg the same

Regards

Vinod