Home » RDBMS Server » Backup & Recovery » RMAN Error (Oracle 10.2.0.1)
RMAN Error [message #442216] Fri, 05 February 2010 07:02 Go to next message
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 #442223 is a reply to message #442216] Fri, 05 February 2010 07:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix the block corruption or tell RMAN to ignore it (and keed it in you backup).

SET MAXCORRRUPT

Regards
Michel
Re: RMAN Error [message #446536 is a reply to message #442216] Tue, 09 March 2010 03:42 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: how use tapdrive for backup
Next Topic: change or scn for incomplete recovery
Goto Forum:
  


Current Time: Mon Dec 05 18:57:17 CST 2016

Total time taken to generate the page: 0.10534 seconds