Home » RDBMS Server » Backup & Recovery » RMAN Corruption (11gR1,RHEL5.1)
RMAN Corruption [message #476154] Tue, 21 September 2010 14:08 Go to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello Senior member,
I am a rookie.
I was running RMAN catalog backupbut got the following errors:
RMAN> backup database tag='FULL_BACKUP';

Starting backup at 21-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=154 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/home/oracle/app/oradata/dimasdb/system01.dbf
input datafile file number=00002 name=/home/oracle/app/oradata/dimasdb/sysaux01.dbf
input datafile file number=00005 name=/home/oracle/app/oradata/dimasdb/example01.dbf
input datafile file number=00003 name=/home/oracle/app/oradata/dimasdb/undotbs01.dbf
input datafile file number=00004 name=/home/oracle/app/oradata/dimasdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-SEP-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/21/2010 14:29:17
ORA-19566: exceeded limit of 0 corrupt blocks for file /home/oracle/app/oradata/

Can you please guide on how to resolve the issue.

Thank you.

David

Report message to a moderator

Re: RMAN Corruption [message #476155 is a reply to message #476154] Tue, 21 September 2010 14:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post the relevant entries in log file.
First check if there is some corruption in files. Use DBV.

Report message to a moderator

Re: RMAN Corruption [message #476178 is a reply to message #476154] Tue, 21 September 2010 21:56 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello
Fine below result of a query and content of my alert log after i got the error:

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
1 46771 1 0 FRACTURED
2 47067 1 0 CORRUPT
2 47055 11 0 ALL ZERO
2 47066 1 0 FRACTURED
2 47068 17 0 ALL ZERO



module='sqlplus@Dimas (TNS V1-V3)' pid='25592'>
<txt>Lost write protection disabled
</txt>
</msg>
<msg time='2010-09-21T14:14:10.730-04:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2995:2802784106' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' module='sqlplus@Dimas (TNS V1-V3)'
pid='25592'>
<txt>Completed: ALTER DATABASE MOUNT
</txt>
</msg>
<msg time='2010-09-21T14:15:01.011-04:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2924:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' module='sqlplus@Dimas (TNS V1-V3)'
pid='25679'>
<txt>alter database archivelog
</txt>
</msg>
<msg time='2010-09-21T14:15:01.766-04:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2995:2802784106' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' module='sqlplus@Dimas (TNS V1-V3)'
pid='25679'>
<txt>Completed: alter database archivelog
</txt>
</msg>
<msg time='2010-09-21T14:17:33.838-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
</txt>
</msg>
<msg time='2010-09-21T14:17:33.839-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>user-specified limit on the amount of space that will be used by this
</txt>
</msg>
<msg time='2010-09-21T14:17:33.839-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>database for recovery-related files, and does not reflect the amount of
</txt>
</msg>
<msg time='2010-09-21T14:17:33.839-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>space available in the underlying filesystem or ASM diskgroup.
</txt>
</msg>
<msg time='2010-09-21T14:29:00.706-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Hex dump of (file 1, block 46771) in trace file /home/oracle/app/diag/rdbms/dimasdb/dimasdb/trace/dimasdb_ora_25758.trc
</txt>
</msg>
<msg time='2010-09-21T14:29:00.841-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Corrupt block relative dba: 0x0040b6b3 (file 1, block 46771)
</txt>
</msg>
<msg time='2010-09-21T14:29:00.841-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Fractured block found during backing up datafile
</txt>
</msg>
<msg time='2010-09-21T14:29:00.841-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Data in bad block:
</txt>
</msg>
<msg time='2010-09-21T14:29:00.842-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt> type: 6 format: 2 rdba: 0x0040b6b3
</txt>
</msg>
<msg time='2010-09-21T14:29:00.842-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt> last change scn: 0x0000.0002ff4b seq: 0x8 flg: 0x04
</txt>
</msg>
<msg time='2010-09-21T14:29:00.842-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt> spare1: 0x0 spare2: 0x0 spare3: 0x0
</txt>
</msg>
<msg time='2010-09-21T14:29:00.843-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt> consistency value in tail: 0x5ad3d08d
</txt>
</msg>
<msg time='2010-09-21T14:29:00.843-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt> check value in block header: 0x9690
</txt>
</msg>
<msg time='2010-09-21T14:29:00.843-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt> computed block checksum: 0xeee1
</txt>
</msg>
<msg time='2010-09-21T14:29:00.844-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Reread of blocknum=46771, file=/home/oracle/app/oradata/dimasdb/system01.dbf. found same corrupt data
</txt>
</msg>
<msg time='2010-09-21T14:29:00.845-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Reread of blocknum=46771, file=/home/oracle/app/oradata/dimasdb/system01.dbf. found same corrupt data
</txt>
</msg>
<msg time='2010-09-21T14:29:00.845-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Reread of blocknum=46771, file=/home/oracle/app/oradata/dimasdb/system01.dbf. found same corrupt data
</txt>
</msg>
<msg time='2010-09-21T14:29:00.845-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Reread of blocknum=46771, file=/home/oracle/app/oradata/dimasdb/system01.dbf. found same corrupt data
</txt>
</msg>
<msg time='2010-09-21T14:29:00.846-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Reread of blocknum=46771, file=/home/oracle/app/oradata/dimasdb/system01.dbf. found same corrupt data
</txt>
</msg>
<msg time='2010-09-21T14:29:06.742-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='backup full datafile' pid='25758'>
<txt>Deleted Oracle managed file /home/oracle/app/flash_recovery_area/DIMASDB/backupset/2010_09_21/o1_mf_nnndf_FULL_BACKUP_69kxoxt7_.bkp
</txt>
</msg>
<msg time='2010-09-21T14:29:07.002-04:00' org_id='oracle' comp_id='rdbms'
msg_id='dbkh_generate_new_failure_alert:2592:3311820762' client_id='' type='ERROR'
group='DRA' level='1' module='backup full datafile'
pid='25758'>
<txt>Checker run found 1 new persistent data failures
</txt>
</msg>

Report message to a moderator

Re: RMAN Corruption [message #476194 is a reply to message #476178] Wed, 22 September 2010 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Find which objects belong to these blocks:
col owner format a15
col segment_name format a30
select e.owner, e.segment_name, e.partition_name, e.segment_type, 
       e.tablespace_name, c.corruption_type
from v$database_block_corruption c, dba_extents e
where e.file_id = c.file#
  and c.block# between e.block_id and e.block_id+e.blocks-1
order by 1, 2, 3
/

Regards
Michel

Report message to a moderator

Re: RMAN Corruption [message #476330 is a reply to message #476194] Wed, 22 September 2010 10:53 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello, below is the result of the query you asked me to run.
Please bear with me and assist me. The whole issue is driving me crazy Mad

SQL> select e.owner,e.segment_name,e.partition_name,e.segment_type,e.tablespace_name,
2 c.corruption_type from v$database_block_corruption c,
3 dba_extents e where e.file_id = c.file# and c.block#
4 between e.block_id and e.block_id+e.blocks-1 order by 1,2,3;

OWNER SEGMENT_NAME PARTITION_NAME
--------------- ------------------------------ ------------------------------
SEGMENT_TYPE TABLESPACE_NAME CORRUPTIO
------------------ ------------------------------ ---------
SYS IDL_UB1$
TABLE SYSTEM FRACTURED

SYSMAN MGMT_CM_BASELINE_PROXYGRANTS
TABLE SYSAUX CORRUPT


Thanks

Panam

Report message to a moderator

Re: RMAN Corruption [message #476334 is a reply to message #476330] Wed, 22 September 2010 11:15 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The first one might really hurt. I think you should open a SR and ask Oracle.

Regards
Michel

Report message to a moderator

Previous Topic: Rman Backup
Next Topic: Restore tablespace without mount database.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 12:52:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.