How to corrupt Oracle Block??

[ora_inf]

Hi:

O.S. => Windows2000
Oracle => 8.1.7

This may sound funny but for my testing purpose I want to corrupt the data block. any suggestion?

Thanks.

[oracbase]

HI ora_inf,

I know there is a build-in tool in Oracle that do block corruption.
In Windows, it is DBV.EXE, but it requires a password to use it.

In Unix, it is also a command called DBV, which requires the DBA to do some re-compiling in order to use it, but no password required.

I came across this when I was looking for a way to test OEM data block corruption event alerts.

Apparently, metalink didn't want to make known how to use such a tool.
I guess only OSS knows how to use it.

Cheers!

[adewri]

Originally posted by oracbase
HI ora_inf,
I know there is a build-in tool in Oracle that do block corruption.
In Windows, it is DBV.EXE, but it requires a password to use it.

DBV is a DB viryfy tool, and is used to find corruption and not to corrupt. And no it doesnot require any passord. Just simple dbv is enough to execute it.

Want to corrupt the data file then use bbed (block browser and editor) utility available in Oracle8i or earlier versions on windows. Its not available in Oracle9i.

[adewri]

Originally posted by oracbase

Apparently, metalink didn't want to make known how to use such a tool.
I guess only OSS knows how to use it.

Cheers!

Common now, who has not heard of DB verify tool... Every one knows about it.

[oracbase]

Sorry guys, wrong info.

The tool I meant was BBED, not DBV.

apologies.

[oracbase]

Hi adewri,

Do you happen to know the password for BBED on windows?

Cheers

[jmodic]

Originally posted by oracbase
In Unix, it is also a command called DBV, which requires the DBA to do some re-compiling in order to use it, but no password required.

FYI, password protection of BBED tool is present in Unix version too, from 8.1.6 onwards.

And no, I don't know the password for this tool. And even if I would know it, I wouldn't reveal it over the internet on such discussion forums. I'm sure Oracle Corp has very strong reasons to protect such a powerfull tool from end user (mis)usage. In fact I think it shouldn't even be included in a database software distribution in the first place - obviously they realized it too, so it's not available from 9i on any more.

[ora_inf]

There is a Tool to corrupt the data block but I can't use it unless I have password.

Thanks for your help.

[pando]

it is still in 9i, you just have to generate it

[guru_heaven]

[oracle@guru_heaven:/u01/app/oracle/product/9iR2/bin]$ bbed
Password: 

BBED: Release 2.0.0.0.0 - Limited Production on Mon Oct 6 18:25:32 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED>