Home » RDBMS Server » Backup & Recovery » Block corruption found during rman (oracle 11.2.0.1 linux)
Block corruption found during rman [message #619836] Fri, 25 July 2014 08:03 Go to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
Newly configured with rman backup and tried to take database backup and ends with below


ora 19566 exceeded limit of 0 corrupt blocks for file rman

Found the block corruption sysaux datafile

rman> backup check logical validate database;

Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 117688
Index 0 60606
Other 10 117467


SQL> select * from V$DATABASE_BLOCK_CORRUPTION
2 ;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
2 18819 3 0 CORRUPT
2 16259 4 0 CORRUPT
2 10755 3 0 CORRUPT
5 55169 1 0 CORRUPT


and in alertlog file:

computed block checksum: 0x0
Reread of blocknum=18820, file=/u02/oradata/RPRODEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18820, file=/u02/oradata/RPRODEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18820, file=/u02/oradata/RPRODEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18820, file=/u02/oradata/RPRODEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18820, file=/u02/oradata/RPRODEV3/sysaux01.dbf. found same corrupt data
Hex dump of (file 2, block 18821) in trace file /u01/oracle/diag/rdbms/rprodev3/RPRODEV3/trace/RPRODEV3_ora_3065.trc
Corrupt block relative dba: 0x00804985 (file 2, block 18821)
Bad header found during validation
Data in bad block:
type: 27 format: 2 rdba: 0x00404985
last change scn: 0x0938.30d30242 seq: 0x1 flg: 0x0c
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x02421b01
check value in block header: 0x4c40
computed block checksum: 0x0
Reread of blocknum=18821, file=/u02/oradata/DEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18821, file=/u02/oradata/DEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18821, file=/u02/oradata/DEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18821, file=/u02/oradata/DEV3/sysaux01.dbf. found same corrupt data
Reread of blocknum=18821, file=/u02/oradata/DEV3/sysaux01.dbf. found same corrupt data
Fri Jul 25 05:34:43 2014
Hex dump of (file 5, block 55169) in trace file /u01/oracle/diag/rdbms/dev3/DEV3/trace/DEV3_ora_3065.trc
Corrupt block relative dba: 0x0140d781 (file 5, block 55169)
Bad header found during validation
Data in bad block:
type: 6 format: 2 rdba: 0x0080d781
last change scn: 0x0938.2acbe29f seq: 0x1 flg: 0x0c
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xe29f0601
check value in block header: 0x434c
computed block checksum: 0x0
Reread of blocknum=55169, file=/u02/oradata/DEV3/apex01.dbf. found same corrupt data
Reread of blocknum=55169, file=/u02/oradata/DEV3/apex01.dbf. found same corrupt data
Reread of blocknum=55169, file=/u02/oradata/DEV3/apex01.dbf. found same corrupt data
Reread of blocknum=55169, file=/u02/oradata/DEV3/apex01.dbf. found same corrupt data
Reread of blocknum=55169, file=/u02/oradata/DEV3/apex01.dbf. found same corrupt data
Fri Jul 25 05:50:09 2014
Checker run found 10 new persistent data failures


Please help on this.

Thanks
Sathish

[Updated on: Fri, 25 July 2014 08:24]

Report message to a moderator

Re: Block corruption found during rman [message #619867 is a reply to message #619836] Fri, 25 July 2014 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59750
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Please help on this.


What do you want?
End the backup with the corruptions or fix the corruptions?

Re: Block corruption found during rman [message #619868 is a reply to message #619867] Fri, 25 July 2014 10:49 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
Can you help me to fix this issue
Re: Block corruption found during rman [message #619869 is a reply to message #619868] Fri, 25 July 2014 11:05 Go to previous message
Michel Cadot
Messages: 59750
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Fix which one?

Previous Topic: Backup fails
Next Topic: Flashback Table gives snapshot too old
Goto Forum:
  


Current Time: Sun Nov 23 09:09:38 CST 2014

Total time taken to generate the page: 0.11064 seconds