How to corrupt Oracle Block??

Printable View

10-03-2003, 09:52 PM
ora_inf

How to corrupt Oracle Block??

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.
10-04-2003, 12:18 AM
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!
10-04-2003, 12:31 AM
adewri

Quote:

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.
10-04-2003, 12:32 AM
adewri

Quote:

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.
10-04-2003, 12:44 AM
oracbase

Sorry guys, wrong info.

The tool I meant was BBED, not DBV.

apologies.
10-04-2003, 12:48 AM
oracbase

Hi adewri,

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

Cheers
10-04-2003, 05:23 AM
jmodic

Quote:

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.
10-05-2003, 09:56 AM
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.
10-06-2003, 05:50 AM
pando

it is still in 9i, you just have to generate it
10-06-2003, 06:11 AM
guru_heaven

Code:

[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>

:o
10-06-2003, 07:36 AM
adewri

Quote:

Originally posted by guru_heaven

Code:

[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>

:o

Thanks, got it, never thought it was available in 9i :)
10-06-2003, 07:40 AM
pando

yup... just look ins_rdbms.mk
10-06-2003, 08:13 AM
adewri

Quote:

Originally posted by pando
yup... just look ins_rdbms.mk

yep already done that :)

Hey pando have you actually tested it. One benifit i could find was that you can read data from a leftout datafile that could not be opened by a database due to one or the other reason. But extracting data from the datafile is one tedious job.
10-06-2003, 08:24 AM
pando

no, I have not, too lazy to read the manual.... probably will try it sometimes next week :D

to extract data they use data unloader or DUL, an Oracle Consulting tool
10-06-2003, 02:13 PM
jmodic

Quote:

Originally posted by pando
it is still in 9i, you just have to generate it

I stand corrected. Got my information obout BBED not being included in 9i distribution from some note/article by Rama Velpuri, a world wide renowned Oracle guru. Obviously he got wrong information too.