checkdb errors in BW systems

[Former Member]

Hi All: i have got 611 errors in my bw systems let me know what can be done to reduce it:::

BR0976W Database message alert - level: ERROR, line: 162, time: 2011-11-01 08.18.28,

ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [34172], [6108], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 646, time: 2011-11-01 08.52.44, message:

ORA-01578: ORACLE data block corrupted (file # 1, block # 34172)

BR0976W Database message alert - level: ERROR, line: 652, time: 2011-11-01 08.52.44, message:

ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [34172], [6108], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 655, time: 2011-11-01 08.52.45, message:

ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [34171], [6108], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 658, time: 2011-11-01 08.52.46, message:

ORA-01578: ORACLE data block corrupted (file # 1, block # 34171)

BR0976W Database message alert - level: ERROR, line: 664, time: 2011-11-01 08.52.46, message:

ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [34171], [6108], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 667, time: 2011-11-01 08.52.48, message:

ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [34168], [6108], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 670, time: 2011-11-01 08.52.49, message:

ORA-01578: ORACLE data block corrupted (file # 1, block # 34168)

BR0976W Database message alert - level: ERROR, line: 1531, time: 2011-11-02 01.55.48, message:

ORA-07445: exception encountered: core dump [00000001005828AC] [SIGSEGV] [Address not mapped to object] [0x0000444DA] [] []

Regards

Ram

[Former Member]

Ramky,

can you check on this hardware where the data is being written.

I hope you might have lost some data too due to this.

Regards

Vivek

[Former Member]

Hi All,

i ran the checkdb again and errors are avoided.And let me know how the below one warning can be avoided too

"BR0981W Not enough disk space for the total maximum size 60000.000 MB of 6 files of tablespace SYSTEM on disk device 17969877, missing at least 45787.812 MB "

I have made the condition inactive in DB17 and still am getting the warning too.Let me know what can be done to avoid this warning

Regards

Ram

[Former Member]

Looks like file system or drive on the server has lack of space to extend te tablespace. Increase the space in file system or Drive and try again.

[Former Member]

Hi ,

I have added data file for the particular tablespace too.I am still facing that warning in checkdb.Should i need to increase disk space for this

Regards

Ram

[Former Member]

Hi Ram,

Please read Arjun's reply again.

Looks like file system or drive on the server has lack of space to extend te tablespace. Increase the space in file system or Drive and try again.

You should increase the underlying drive / filesystem size rather than increasing / extending the tablespace.

Or probably you can either resize / move the datafiles of SYSTEM tablespace.

Br,

Venky

[Former Member]

thanks for all your valuable support

Regards

Ram

[Former Member]

Ramky,

ORA-01578: ORACLE data block corrupted (file # 1, block # 34168)

Looks like DB block has encountered corruption. goto DB16 and Click the START button and wait for the results. Log will show you, If there are any corruption in the DB.

[Former Member]

Also check the database parameters as per note 1171650.

Note 547464 - Nologging Option when creating indexes

Br,

Venky

[Former Member]

Hi,

Are you getting these messages after any maintenance activity?

Br,

Venky