How to corrupt Oracle Block??
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: How to corrupt Oracle Block??

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    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.

  2. #2
    Join Date
    Apr 2001
    Posts
    110
    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?

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Apr 2001
    Posts
    110
    Sorry guys, wrong info.

    The tool I meant was BBED, not DBV.

    apologies.
    What's next after 10g?

  6. #6
    Join Date
    Apr 2001
    Posts
    110
    Hi adewri,

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

    Cheers
    What's next after 10g?

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  8. #8
    Join Date
    Jan 2001
    Posts
    230
    There is a Tool to corrupt the data block but I can't use it unless I have password.

    Thanks for your help.

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    it is still in 9i, you just have to generate it

  10. #10
    Join Date
    Feb 2003
    Posts
    85
    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
  •  



Click Here to Expand Forum to Full Width