Urgent, DB cannot open.

[Kenn Chen]

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'

[James R. Ferguson · Accepted solution]

Hi:

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

...JRF...

[David LaPoint]

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.