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!