| Block corruption found during rman [message #619836] |
Fri, 25 July 2014 08:03  |
 |
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 #628318 is a reply to message #619869] |
Mon, 24 November 2014 00:35  |
 |
DbaKazim
Messages: 1
Registered: November 2014
Location: India
|
Junior Member |
|
|
Hi , I had a Similar problem during Rman Backup and we tried to set maxcorrupt for that datafile (in My case 32) to like 5 and edited the Rman command in as below
set maxcorrupt for datafile 32 to 5;
You can try to do that and check or go to support.oracle.com and read this Document
Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g (Doc ID 28814.1)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
