Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent, DB cannot open.

SOLVED
Go to solution
Kenn Chen
Advisor

Urgent, DB cannot open.

My db cannot be up and below is the error message :- any one can help me.

SVRMGR> connect internal
Connected to an idle instance.
SVRMGR> shutdown immediate;
ORA-01012: not logged on
SVRMGR> startup
ORACLE instance started.
Total System Global Area 4197848 bytes
Fixed Size 38984 bytes
Variable Size 4027792 bytes
Database Buffers 122880 bytes
Redo Buffers 8192 bytes
Database mounted.
ORA-00255: error archiving log 1 of thread 1, sequence # 673
ORA-00312: online log 1 thread 1: '/oracle/MIS/oradata/catalog/redo_01.dbf'
ORA-00272: error writing archive log
ORA-00334: archived log: '/oracle/MIS/arch/catalog/catalog_673.ARC'
Cyber Zen
2 REPLIES
James R. Ferguson
Acclaimed Contributor
Solution

Re: Urgent, DB cannot open.

Hi:

Make sure that the filesystem that contains the archive logs isn't full.

...JRF...
David LaPoint
Occasional Advisor

Re: Urgent, DB cannot open.

I suspect that you have solved your problem. But a tip for the future.

When have some error like you got, you should also check your Oracle alert log. It's like the syslog for HP. By convention, it's in $ORACLE_BASE/admin/$ORACLE_SID/bdump. And the name is alert_$ORACLE_SID.log. A stuck archiving process will be shown there.
You want to ask me a quick question? Sure! You can have the quick answer too, 42!