Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-19566:

user151917Apr 17 2013 — edited May 29 2013
DB 11.1.0.7.0

When I am running rman backup it is giving below error . To check whether it is corrupted file in database using dbv yes it gave there is a system file corrupted as below.

Error while taking rman backup

ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/data/system09.dbf
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 17-APR-13
channel ORA_DISK_1: finished piece 1 at 17-APR-13
piece handle=/u01/backup/backup_FULL_PROD_05o7aj3v_5 tag=TAG20130417T152837 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

---while running dbv

Page 165657 is marked corrupt
Corrupt block relative dba: 0x58028719 (file 352, block 165657)
Completely zero block found during dbv:

Page 165658 is marked corrupt
Corrupt block relative dba: 0x5802871a (file 352, block 165658)
Completely zero block found during dbv:

Page 165659 is marked corrupt
Corrupt block relative dba: 0x5802871b (file 352, block 165659)
Completely zero block found during dbv:

--- so on

Thanks

Edited by: user11969485 on Apr 19, 2013 11:55 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2013
Added on Apr 17 2013
23 comments
4,296 views