ORA-16038, ORA-19502 and ORA-27063 messages in DB16

[Former Member]

Hi experts,

I found below messages in DB16.(SAP version ECC 6.0 & oracle 10.2.0.2)

ORA-16038 Check 11.04.2011 21:00:04 - Time: 2011-04-11 09.47.15, line: ORA-16038 signalled during: ALTER DATABASE OPEN...

ORA-19502 Check 11.04.2011 21:00:04 - Time: 2011-04-11 05.25.41, line: ORA-19502: write error on file "/oracle/QO1/oraarch/QO1arch1_161

ORA-27063 Check 11.04.2011 21:00:04 - Time: 2011-04-11 05.26.19, line: ORA-27063: number of bytes read/written is incorrect

Please suggest me to avoid those errors and are those messages serious errors or not.

Thanks in advance !!!!!!!

Regards

Veera

Edited by: Veerab on Apr 12, 2011 11:49 AM

[audunlea_hansen · Accepted solution]

Hi!

Have you checked there are enough space on disk where arch-files are located? Those error messages normally indicate full disk.

Try to change or add another arch destination on another disk to be shore not losing any arch-files.

Use db-verify to check files for block corruption.

If you find block corruption, let your storage-people know and ask them to do a check of disk on OS-level.

Please verify your backups to be shore you doesn't have trouble with files backed up.

Regards

Audun

DBA

[former_member213250]

Hello Mr. Veera

From the error messages you mentioned it seems the issue is related to Archiver Stuck situation.

If you have done a basic analysis regards to these errors you might have get lot of hits to solve this

issue.

refer to procedures given in SAP Note : 391. should be helpful

BR

Venkat