cancel
Showing results for 
Search instead for 
Did you mean: 

DB error

Former Member
0 Kudos

Dear all,

AIX , SAP ecc6.0 , Oracle 10g

SQL> startup

ORACLE instance started.

Total System Global Area 4513071104 bytes

Fixed Size 2077176 bytes

Variable Size 2264927752 bytes

Database Buffers 2231369728 bytes

Redo Buffers 14696448 bytes

Database mounted.

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

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

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

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

SQL>

kindly advise

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member524429
Active Contributor
0 Kudos

Hi,

The possible reasons for such issue may be one of the following or both :

1. Archive Log Destination is full, Space issue. e.g. ORAARCH or SAPARCH folder.

2. The Oracle Instance was not properly shutdown.

Shutdown Oracle Instance completely. You can use shutdown immediate/abort command options.

If the space issue is there with Archive destination folder, then try to move some old Offline redo log file to other safe location as a backup copies and try to restart the Oracle Instance again.

Regards,

Bhavik G. Shroff

Former Member
0 Kudos

Hi,

This is definitely because of the archive stuck. that means your archive directory is full. Please backup the archive log files and then delete some files then try to start the database.

Thanks,

Chaitanya

Former Member
0 Kudos

dear ,

yes your correct . during the client copy . ORAARCH is full .

i had tried to start DB but even through its not started .

Kindly Suggest .

former_member524429
Active Contributor
0 Kudos

Hi,

ORAARCH is having sufficient free space ?

Have you tried to start the oracle instance after completely shutdown Oracle Instance using "shutdown abort" ?

Regards,

Bhavik G. Shroff

ashish_mishra2
Contributor
0 Kudos

You have to manuallly move the redolog files to any other filesystem or take the backup and make some free space available in oraarch before trying to start the database.

Cheers !!!

Ashish

.

Former Member
0 Kudos

Dear All,

I had started DB using BRtools. without take the ORAARCH Backup

now both DB and SAP also working and Client copy also completed .

Users could not able access some MM & FI related transaction . they got the ABAP runtime error .

now i am getting lots of ABAP Dump error .

i dont think so why i got the below Runtime error Dump. which is due to DB kindly advise .

Kindly check the below log :

Short text

Inconsistency in the Dictionary for the structure "KOMG".

What happened?

Error in the SAP kernel.

The current ABAP "SAPLTAX2" program had to be terminated because the

ABAP processor detected an internal system error.

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Error analysis

There is an internal system error.

eliminated with ABAP/4.

ashish_mishra2
Contributor
0 Kudos

>

>

> Short text

> Inconsistency in the Dictionary for the structure "KOMG".

>

Please check if there was any error thrown during client copy against this table?

Check the consistency of this table from SE11 --> Display the table

menu --> structure --> check

Cheers !!!

Ashish