Problem with starting SAP Database ..

Former Member · ‎11-15-2008

Hi,

I have a issue with starting the DB. the detailed log is attached below.

When I had a Performance issue, I had tried to stop the SAP instance and the DB.

But thats not stopped. So I have restarted the OS.

After restarting the OS the DB is not comming up.

Its throwing the following log

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Nov 15 13:11:16 2008

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2365587456 bytes

Fixed Size 2057952 bytes

Variable Size 1191184672 bytes

Database Buffers 1157627904 bytes

Redo Buffers 14716928 bytes

Database mounted.

ORA-16038: log 4 sequence# 3468 cannot be archived

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

ORA-00312: online log 4 thread 1: '/oracle/TRQ/origlogB/log_g14m1.dbf'

ORA-00312: online log 4 thread 1: '/oracle/TRQ/mirrlogB/log_g14m2.dbf'

Please give me an solution to solve this issue.

Thanx & Regards,

Kumar

Former Member · ‎11-15-2008

>ORA-16038: log 4 sequence# 3468 cannot be archived

the problem is your archive directory is full. take archive log backup or move old archive log files to another location.

follow Note 391 - Archiver stuck

Cheers,

-Sunil

Re: ASEGURAMIENTO DE TABLAS