Question Re: Error ORA-00313 in Technology Q&A

Error ORA-00313

Former Member — Tue, 05 Dec 2006 06:16:03 GMT

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

Re: Error ORA-00313

Former Member — Tue, 05 Dec 2006 06:42:11 GMT

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.

Re: Error ORA-00313

Former Member — Tue, 05 Dec 2006 07:23:15 GMT

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

Re: Error ORA-00313

Former Member — Tue, 05 Dec 2006 12:48:04 GMT

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

Re: Error ORA-00313

Former Member — Mon, 25 Dec 2006 10:37:38 GMT

Hi GAnesh,

Is your prob resolved?

Re: Error ORA-00313

Former Member — Wed, 27 Dec 2006 15:35:27 GMT

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'"