Re: RMAN backup and get bad block error messages?
Date: Thu, 30 Jul 2009 08:55:19 -0400
Message-ID: <OF8163BA2A.3A81FA58-ON85257603.0046C889-85257603.0046FBDE_at_lnotes-gw.ent.nwie.net>
Answer to #1, is hot/cold backup don't care, they don't do block checking where as RMAN will.
As to how to fix it, well since it kinda sorta looks like the system tablespace, my first thing would be to call support. I can't quite tell if it is or not.
joe
Joe Testa, Oracle Certified Professional
(Work) 614-677-1668
(Cell) 614-312-6715
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
From:
dba1 mcc <mccdba1_at_yahoo.com>
To:
oracle-l_at_freelists.org
Date:
07/30/2009 08:12 AM
Subject:
RMAN backup and get bad block error messages?
Sent by:
oracle-l-bounce_at_freelists.org
we have ORACLE 11G on LINUX server. We just created a new EBS system and perform the database backup. When I do "cold backup" and "hot backup", there is NO error. While I perform RMAN backup and I got error messages:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/29/2009
20:38:42
ORA-19566: exceeded limit of 0 corrupt blocks for file
/u/EBS/EBSDB01/db/apps_st/data/system04.dbf
Alter.log also have messages:
Hex dump of (file 352, block 165656) in trace file
/u/EBS/EBSDB01/db/tech_st/11.1.0/admin/XXX/diag/rdbms/ebsdb01/EBSDB01/trace/EBSDB01_ora_6824.trc
Corrupt block relative dba: 0x58028718 (file 352, block 165656)
Completely zero block found during backing up datafile
Reread of blocknum=165656,
file=/u/EBS/EBSDB01/db/apps_st/data/system04.dbf. found same corrupt data
My question are:
- Why "cold backup" and "hot backup" Not complain, but RMAN complain?
- how to fix this bad block without lost data?
Thanks.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 30 2009 - 07:55:19 CDT