Oracle databse cannot be started .

[Former Member]

Hi,

I am facing this error while starting up SAP .Please advice how do I bringup the system.Please note that the databse is running on no archive mode and there is no back up also .

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1478446944 bytes

Fixed Size 728928 bytes

Variable Size 771751936 bytes

Database Buffers 704643072 bytes

Redo Buffers 1323008 bytes

Database mounted.

ORA-16038: log 1 sequence# 736 cannot be archived

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

ORA-00312: online log 1 thread 1: '/oracle/DS1/origlogA/log_g11m1.dbf'

ORA-00312: online log 1 thread 1: '/oracle/DS1/mirrlogA/log_g11m2.dbf'

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.6.0 - Production

-

---

Tue Jun 3 22:13:23 SST 2008

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/DS1/SYS/exe/run/startdb: Terminating with error code 12

Thanks,

Suman

[Former Member]

Hi All,

this was file system full issue only .

Thanks everybody for replying.

[Former Member]

Could be an operating system problem.

Check if directory /oracle/DS1/mirrlogA is mounted.

What are the permissions of file /oracle/DS1/origlogA/log_g11m1.dbf ?

Any error messages in your Unix system log files?

hope this helps

[Former Member]

Hi,

Thanks for your reply.How do I check the note ?

Please note that the database is running on no archive mode.

Please let me know how do I start oracle and then SAP .

Thanks,

Suman

[Former Member]

Hello,

check this note

Note 391 - Archiver stuck