| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How can I get the BBED password?
We use monitors on v$database_block_corruption to see corruption that =
RMAN does not report in it's logs, but does always appear to report in =
the view, which is really rows stored in the controlfile.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Slava Zayarny
Sent: Thursday, April 14, 2005 6:56 AM
To: Oracle-L_at_freelists.org
Cc: breitliw_at_centrexcc.com
Subject: Re: How can I get the BBED password?
Wolfgang,
I have recently been looking at what types of corruption RMAN notices
and how it reports them. I used dd and BBED to experiment with =3D
intentional
block corruption in 9.2.0.6/HP-UX 11.11.
I have not had the time to conclude all the trials I want but BBED only =
=3D
marks=3D20
a block "FRACTURED" as seen in V$DATABASE_BLOCK_CORRUPTION
after RMAN's "BACKUP VALIDATE CHECK LOGICAL DATABASE" is run. =3D20
For this type of corruption RMAN does NOT fail with an error after =3D
backup=3D20
validation: it logs an entry to the alert log and inserts rows into=3D20
V$DATABASE_BLOCK_CORRUPTION and V$BACKUP_CORRUPTION. Alert log would =
=3D
show
such intentionally fractured block in the alert log as:
"Bad header found during backing up datafile"
without the usual "ORA-XXX".
RMAN behaved differently in a recent case where corrupted block was reported in alert log as:
"Bad header found during buffer read"
In that case RMAN failed with "ORA-19566: exceeded limit of 0 corrupt =
=3D
blocks for file".
It was also reported with "ORA-XXX" into the alert log. Unfortunately, =
=3D
I don't have=3D20
details on how it was reported in V$DATABASE_BLOCK_CORRUPTION.
I think it's important to know what kind of corruption RMAN can and =3D
cannot
report without the need to add auto monitoring of the alert log beyond =
=3D
the standard
"ORA-XXX" strings.
What I want to figure out conclusively by simulation is how RMAN reports =
=3D
the=3D20
other four types of corruption (as seen in V$DATABASE_BLOCK_CORRUPTION):
ALL ZERO, CHECKSUM, CORRUPT, LOGICAL
I will share my findings when I'm done, but in the meantime, I would =3D
welcome
your comments if you have any.
Cheers,
Slava Zayarny
Oracle DBA
Date: Wed, 13 Apr 2005 12:43:24 -0600
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Subject: Re: How can I get the BBED password?
I have used it to deliberately corrupt a block to find out how RMAN=3D20 report block corruptions. Of course there are other ways to corrupt=3D20 blocks but it seemed like a good excuse to build and use bbed.
Guerra, Abraham J wrote:
> Hello Tanel,
>=3D20
> Have you used the utility? If so, did you discover the password or =
=3D
=3D3D
> somebody else told it to you?
>=3D20
>=3D20
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 15 2005 - 00:29:01 CDT
 |
 |