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!

corruption reading backup piece

689671Feb 14 2011 — edited Feb 14 2011
Hi

i'm creating a standby database and i have a problem when i'm issuing following command

rman> restore database;

The alert log shows:

--------------------------------------------------------------------------------

Reading datafile '/u01/app/oracle/oradata/orcl/users01.dbf' for corruption at rdba: 0x06400001 (file 4, block 1)
Reread (file 1, block 1) found same corrupt data
Corrupt block relative dba: 0x07400001 (file 1, block 1)
Bad header found during kcvxfh v8
Data in bad block:
type: 0 format: 2 rdba: 0x07400001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0xa041
computed block checksum: 0x0
Reading datafile '/u01/app/oracle/oradata/orcl/users01.dbf' for corruption at rdba: 0x07400001 (file 1, block 1)
Reread (file 29, block 1) found same corrupt data
Mon Feb 07 18:30:10 2011
Full restore complete of datafile 4 /u01/app/oracle/oradata/orcl/users01.dbf. Elapsed time: 1:02:20
checkpoint is 2576268845

RMAN log indicates:

--------------------------------------------------------------------------------
.............
.............
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/FRADISK/orcl/backupset/2011_02_10/0QGB0UEC1_2_.BAK tag=TAG20110210T152709
channel ORA_DISK_1: restore complete
Finished restore at 11/FEB/11


the datafile is restored but RMAN reread the piece of backup twice or more by each datafile

also i issue VALIDATE command for the backup RMAN and it was successful

My environment is:
Oracle Virtual Server with 1 Virtual Machine "Red Hat Enterprise Linux 5.5 64 bits"
Oracle 11g Release 2
4 GB RAM
1 hd internal => 70GB
1 lun of storage => 500GB

any idea?
should I worry?

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2011
Added on Feb 14 2011
1 comment
1,142 views