ORA 16038 - VERY URGENT | PLEASE HELP

[Former Member]

Hi all,

All of a sudden , our production went down . When i checked the system, i realised that Oracle was down. I tried to start the database but got the error. I'm having HP-UX, Oracle 8.1.7.2 and R/3 4.6C. Please help me out.

the error i got was -

SAPDBA: Trying to start and open instance IP1

using STARTUP OPEN ...

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production

With the Partitioning option

JServer Release 8.1.7.2.0 - 64bit Production

Connected.

ORACLE instance started.

Total System Global Area 4446202344 bytes

Fixed Size 104936 bytes

Variable Size 771534848 bytes

Database Buffers 3672195072 bytes

Redo Buffers 2367488 bytes

Database mounted.

ORA-16038: log 16 sequence# 94 cannot be archived

ORA-19502: write error on file "", blockno (blocksize=)

ORA-00312: online log 16 thread 1: '/oracle/IP1/origlogB/log_g16m1.dbf'

ORA-00312: online log 16 thread 1: '/oracle/IP1/mirrlogB/log_g16m2.dbf'

Server Manager complete.

PLEASE HELP

[Former Member]

The saparch Was filled up. We cleaned it and it worked. Thanks for your help.

[manu_susankar]

Hi

Check the following link....

http://www.orafaq.com/forum/t/51251/0/

Regards...

S.Manu

[Former Member]

NK,

Can u check the filesystems "/oracle/IP1/origlogB/" & "/oracle/IP1/mirrlogB/" and are not filled and has oraip1:dba ownership and exist.

Also check your archive directory space.

Regards,

Vijay

[manu_susankar]

Hi

Try this go to SQL Plus as sysdba and execute startup mount, once mounted exccute ALTER SYSTEM SWITCH LOGFILE;

then execute startup.Hope this fix your.I would sugges you please take the assitence of DBA before executing this.

Regards...

S.Manu