| RMAN Error [message #442216] |
Fri, 05 February 2010 07:02  |
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
|
Member |
|
|
Hi,
From last few days we are facing the error while taking RMAN backup.
RMAN-03009: failure of backup command on ch00 channel at 02/04/2010 23:34:43
ORA-19566: exceeded limit of 0 corrupt blocks for file /db/FINPRODDATA/oradata/psindex.dbf
Alert log shows:
Corrupt Block Found
TSN = 141, TSNAME = PSINDEX
RFN = 140, BLK = 3224639, RDBA = 590427199
OBJN = 39883, OBJD = 39883, OBJECT = PS_PSAPMSGPUBDATA, SUBOBJECT =
SEGMENT OWNER = SYSADM, SEGMENT TYPE = Index Segment
Wed Feb 3 22:29:56 2010
Corrupt Block Found
TSN = 141, TSNAME = PSINDEX
RFN = 140, BLK = 3224639, RDBA = 590427199
OBJN = 39883, OBJD = 39883, OBJECT = PS_PSAPMSGPUBDATA, SUBOBJECT =
SEGMENT OWNER = SYSADM, SEGMENT TYPE = Index Segment
Wed Feb 3 22:55:22 2010
Thread 1 advanced to log sequence 1716
Current log# 3 seq# 1716 mem# 0: /db/FINPRODDATA/logs/redo03.log
Thu Feb 4 00:07:10 2010
Hex dump of (file 140, block 3224639) in trace file /db/FINPRODDATA/udump/finprod_ora_28182.trc
Corrupt block relative dba: 0x2331343f (file 140, block 3224639)
Fractured block found during backing up datafile
Data in bad block:
type: 6 format: 2 rdba: 0x2331343f
last change scn: 0x0000.462b3d36 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x73646e6f
check value in block header: 0x4e79
computed block checksum: 0xa07a
Reread of blocknum=3224639, file=/db/FINPRODDATA/oradata/psindex.dbf. found same corrupt data
Reread of blocknum=3224639, file=/db/FINPRODDATA/oradata/psindex.dbf. found same corrupt data
Reread of blocknum=3224639, file=/db/FINPRODDATA/oradata/psindex.dbf. found same corrupt data
Reread of blocknum=3224639, file=/db/FINPRODDATA/oradata/psindex.dbf. found same corrupt data
Reread of blocknum=3224639, file=/db/FINPRODDATA/oradata/psindex.dbf. found same corrupt data
Kindly let we know how to approach for this.
Thanks
|
|
|
|
|
|
| Re: RMAN Error [message #446536 is a reply to message #442216] |
Tue, 09 March 2010 03:42  |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
Hi,
You can try the below approach:-
1. First check the datafile number[psindex.dbf] from v$datafile.
2. Run
{SET MAXCORRUPT FOR DATAFILE <<NO>> to 10;
ALLOCATE CHANNEL CH1 TYPE DISK FORMAT 'U%';
BACKUP DATABASE PLUS ARCHIVELOG ALL;
RELEASE CHANNEL CH1;
}
Thanks-
P
|
|
|
|
| Re: RMAN Error [message #446541 is a reply to message #446536] |
Tue, 09 March 2010 04:29 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Will you search all posts that are ended a month ago to (approximatively) repeat the same thing that has already been posted?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
