Database Backup and Recovery (MOSC)

MOSC Banner

ORACLE data block corrupted

edited Mar 5, 2025 8:29AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Hi Team,

Please provide solution as soon as possible.

Errors in file /u01/nautilus/app/diag/rdbms/nunprdqa/NUNPRDQA/trace/NUNPRDQA_smon_149587.trc:ORA-01578: ORACLE data block corrupted (file # 22, block # 51458)

ORA-01110: data file 22: '/d03/nautilus/oradata/NUNPRDQA/datafile/LIMS_TEST02.dbf'

DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)

ORA-01110: data file 22: '/d03/nautilus/oradata/NUNPRDQA/datafile/LIMS_TEST02.dbf'

Byte offset to file# 22 block# 51458 is 421543936

2025-03-04T10:38:32.264693+01:00

Incident 285651 created, dump file: /u01/nautilus/app/diag/rdbms/nunprdqa/NUNPRDQA/incident/incdir_285651/NUNPRDQA_smon_149587_i285651.trc

ORA-01578: ORACLE data block corrupted (file # 22, block # 51458)

ORA-01110: data file 22: '/d03/nautilus/oradata/NUNPRDQA/datafile/LIMS_TEST02.dbf'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center