-
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.
-
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!
What's next after 10g?
-
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.
Amar
"There is a difference between knowing the path and walking the path."
-
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.
Amar
"There is a difference between knowing the path and walking the path."
-
Sorry guys, wrong info.
The tool I meant was BBED, not DBV.
apologies.
What's next after 10g?
-
Hi adewri,
Do you happen to know the password for BBED on windows?
Cheers
What's next after 10g?
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
There is a Tool to corrupt the data block but I can't use it unless I have password.
Thanks for your help.
-
it is still in 9i, you just have to generate it
-
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>
Last edited by guru_heaven; 10-06-2003 at 06:13 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|