on 12-05-2006 6:16 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.