error in the database check.

[Former Member]

hi all,

I am getting following error while doing Database check in my system:

BR0976W Database message alert - level: ERROR, line: 7649, time: 2010-08-26 22.56.27, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7650, time: 2010-08-26 22.56.27, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7654, time: 2010-08-26 22.56.27, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7657, time: 2010-08-26 22.56.27, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7658, time: 2010-08-26 22.56.27, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7662, time: 2010-08-26 22.56.27, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7669, time: 2010-08-26 22.56.27, message:

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

BR0976W Database message alert - level: ERROR, line: 7670, time: 2010-08-26 22.56.27, message:

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

BR0976W Database message alert - level: ERROR, line: 7675, time: 2010-08-26 22.56.27, message:

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

BR0976W Database message alert - level: ERROR, line: 7676, time: 2010-08-26 22.56.27, message:

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

BR0976W Database message alert - level: ERROR, line: 7686, time: 2010-08-26 22.57.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7687, time: 2010-08-26 22.57.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7691, time: 2010-08-26 22.57.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7694, time: 2010-08-26 22.57.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7695, time: 2010-08-26 22.57.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7699, time: 2010-08-26 22.57.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7709, time: 2010-08-26 22.58.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7710, time: 2010-08-26 22.58.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7714, time: 2010-08-26 22.58.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7717, time: 2010-08-26 22.58.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7718, time: 2010-08-26 22.58.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7722, time: 2010-08-26 22.58.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7734, time: 2010-08-26 22.59.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 69633 (blocksize=512)

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 69633 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7735, time: 2010-08-26 22.59.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7739, time: 2010-08-26 22.59.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 69633 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7742, time: 2010-08-26 22.59.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 69633 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7743, time: 2010-08-26 22.59.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7747, time: 2010-08-26 22.59.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 69633 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7757, time: 2010-08-26 22.59.04, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7758, time: 2010-08-26 22.59.04, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7762, time: 2010-08-26 22.59.04, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7765, time: 2010-08-26 22.59.04, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7766, time: 2010-08-26 22.59.04, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7770, time: 2010-08-26 22.59.04, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7780, time: 2010-08-26 23.00.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7781, time: 2010-08-26 23.00.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7785, time: 2010-08-26 23.00.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7798, time: 2010-08-26 23.00.10, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 77825 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7799, time: 2010-08-26 23.00.10, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7803, time: 2010-08-26 23.00.10, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 77825 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7811, time: 2010-08-26 23.01.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7812, time: 2010-08-26 23.01.02, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7816, time: 2010-08-26 23.01.02, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7826, time: 2010-08-26 23.02.03, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7827, time: 2010-08-26 23.02.03, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7831, time: 2010-08-26 23.02.03, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 63489 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7839, time: 2010-08-26 23.03.03, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 77825 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7840, time: 2010-08-26 23.03.03, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7844, time: 2010-08-26 23.03.03, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 77825 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7857, time: 2010-08-26 23.03.42, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7858, time: 2010-08-26 23.03.42, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7862, time: 2010-08-26 23.03.42, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7870, time: 2010-08-26 23.04.03, message:

ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf", blockno 65537 (blocksize=512)

BR0976W Database message alert - level: ERROR, line: 7871, time: 2010-08-26 23.04.03, message:

ORA-27063: number of bytes read/written is incorrect

BR0976W Database message alert - level: ERROR, line: 7875, time: 2010-08-26 23.04.03, message:

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14251008 (>< 4096,512 KB)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (set in parameter file)

BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)

BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

What are these and how to rectify these?

Regards,

Priya

[former_member227281 · Accepted solution]

Hi Priya,

When you perform database check either using brtools or in tx code db13, SAP will check the health of database system by reading the content of alert_<SID>.log file located in /oracle/<SID>/saptrace/background. Also it checks the contents of database parameters as per the threshold configuration in tx code db17.

The content of oracle alert log file showed that it cannot write archive log file.. Please see the content of alert_<SID>.log file and correct the archive log error creation. The error indicates that either disk block is corrupted or damaged.

As seen in the error message the error message was created in the month of Aug 2010 and appended in the alert_IRQ.log file located in /oracle/IRQ/saptrace/background.If the error is not present now and if you want to perform database check, then delete old contents from the first line to till last month in alert_IRQ.log file using operating system. Then save the file and Then perform database check again.

Please make sure you must monitor database check daily and ensure that if the error occurs for writing archive log file, it is dangerous as archive will stuck and the whole operation hangs.

The message below is for warning and this can be ignored and this is becasue of threshold configuration. You may change the threshold configuration in tx code db17.

However warning " WARNING, parameter: LOG_BUFFER, value: 14251008 (>< 4096,512 KB) BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (set in parameter file) BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096) BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE) BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE ( FALSE) BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE ( TRUE) BR0978W Database profile alert - level: WARNING, parameter" - is for warning only it could be bug problems. SO there is no need to correct the problem.

Hope this helps you.

Thanks and Regards

apr

[Former Member]

Hi

BR0976W Database message alert - level: ERROR, line: 7649, time: 2010-08-26 22.56.27, message: ORA-19502: write error on file "/oracle/IRQ/oraarch/IRQarch1_28567_661029934.dbf",

It seems the logs shown are old .Pl perform cleanup log action from DB13 and then perform database check and post the same

Regards

Jasmeen