ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data (r12)

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data

Yesterday, during RMAN (11g) backup the aforementioned issue was raised and resolved by following the enclosed Document.

Error: ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/PROD/db/apps_st/data/system09.dbf

Alert Log Entry: Reread of blocknum=165656, file=/oracle/PROD/db/apps_st/data/system09.dbf. found same corrupt data

Dont forget to Contact Oracle Support for any further Clarification.

About the Author Muhammad Rawish Siddiqui

Master in Computer Science and Post-Graduation in MIS. EDRP (EC-Council Disaster Recovery Professional), Security+, OCP 7.3, 10, 11g, 12c, 11i, R12, OCE 11i System Administration, Linux and RAC 10g, 11g, and OCS in Performance Tuning. More than 18 years’ Information Technology consecutive hands-on experience, possess diversified business and technical background on a wide variety platforms, hardware and operating systems, in the Capacity of Sr. Team Lead Consultant, Sr. Database Administrator, Sr. Applications DBA, Sr. Resident Consultant and Manager Systems. Extensive experience in managing ERP environments and large Databases including Space Management, Backup and Recover, Performance Tuning, Routine Tasks Automation and Database/Applications Health Checks. Started Oracle related Career from Oracle 6. Worked on 7, 8, 9i, 10g, 11g, 12c & e-Business 11.0.3, 11.5.9, 11.5.10.2, R12 and R12.2. Distinct Technical Jobs such as installation, migration, implementation, upgrade, cloning, and maintenance were performed hundreds number of times. Database and Applications (Security & Performance) related Health Checks, RAC & Data Guard Implementation/Troubleshooting Switchover/Failover were also made during the tenure on the basis of As-When-Needed. Contact Me for Database/Applications Installation, Upgrade, Migration, Disaster Recovery, Troubleshooting and Health Checks.

Leave a Comment:

4 comments
ram says April 25, 2010

Hi,

We are getting this error from last one month in our 11g database…I got a hit in metalink it is resizing of particular datafile.

But still we are getting the same error in other databases..Do you guys have any other solution?

Regards,
Mahender.

Reply
Bhavesh says April 27, 2010

Atul,

Had this issue after multiple installation of R12.0.4 on Linux 64 bit. Had resized the system09.dbf file and issue got resolved. There is a metalink document for this issue. Not sure whether this issue persists for other platforms as well

Regards
Bhavesh.

Reply
Muhammad Rawish Siddiqui says April 27, 2010

Dear Mahender

The Corrupted Blocks are Unused or belong to Segments?

Reply
athaullah says January 2, 2013

Please provide me an apps. DBA R12 Resume and 12.0.4-12.1.1 & 12.1.1-12.1.3 (document file) on paradise_437@yahoo.com

Reply
Add Your Reply

Not found