Thursday, February 15, 2007

DBVerify? I think not.

Waaay back when I was younger and worked in Oracle Support we were competing fiercely (and with any weapon) against Informix, Ingres and Sybase.

Especially Sybase was the great enemy, and we used to laugh a lot about their DBVerify facility, which their Support organisation required their users to run before they called Sybase Support.

Since running DBVerify could take more than 24 hours if the Sybase database was sufficiently large, it was obvious to any idiot that it didn't make sense. And why did they need such a facility? Didn't they have faith in the DBMS' ability to keep blocks out of corruption charges?

DBVerify was mentioned in Oracle competitive marketing materials as one good argument for not choosing Sybase.

Then Oracle copied it, including its name. Incredible. And to this date it is - if possible - even more useless than its Sybase forefather.

Yesterday I had a conference call with a large customer who had been down with their CRM system because DBVerify told them they had numerous corrupted blocks in their database after a restore and some reorg stuff.

I simply told them to ignore this bug in dbv (newed blocks are flagged as corrupted) and only think in terms of corrupted blocks if they ever see an ORA-1578 in their alert log.

They didn't quite believe me (it's an official Oracle utility, after all, this dbv nonsense), so I had to explain all sorts of stuff about block internals, checksums, hard and soft corruptions, and what have you.

In the end I promised them that I'd give them all the consulting help they'd need to fix corrupted blocks if they had any - and to just put the system back in production.

But imagine: A large company, down for five days because of the age-old bug/issue with dbverify calling blocks corrupted when they're not - and Oracle Support (and other involved parties) not knowing that it's just nonsense because they might not be aware of its history.

Spread the word: Stop using the useless piece of c... known as dbverify :-))).

17 Comments:

Blogger EscVector said...

You can't be serious. Give up all those consulting hours! I hope they don't find out about RMAN. Long live the old and archaic!

2:04 PM  
Anonymous egapcr said...

As a long time Sybase DBA, I can tell you that we NEEDED Sybase dbcc's. I had so many late nights because Sybase used to corrupt all over the place. It was one of the big selling points in my win to switch over to Oracle.

5:34 PM  
Blogger Noons said...

can you imagine if RMAN had been copied from Sybase as well?
:-)

8:55 AM  
Anonymous Kevin said...

History is more important than hysteria. Good blog entry, Moans.

8:53 PM  
Blogger rong said...

your article is very good, but do you like the
pink ghd
babyliss
armani sunglasses
gucci sunglasses outlet
discount abercrombie and fitch clothes
abercrombie fitch outlet
abercrombie & fitch clothing
ed hardy wholesale
cheap ed hardy wholesale
discount ed hardy wholesale
wholesale ed hardy
ed hardy outlet
paul smith shirt
paul smith
paul smith 2010
cheap paul smith
discount paul smith
paul smith shoes
Burberry scarf
Burberry outlet
cheap Burberry handbags
Burberry totes
newest Burberry
moncler
Moncler jackets
Moncler coats
Moncler Vest
discount Moncler outlet
moncler polo t shirt
cheap ugg boots
discount ugg boots
ugg boots
classic ugg boots
ugg classic tall boots
AirMax BW
AirMax Huarache
AirMax LTD
AirMax Skyline
AirMax TN

7:19 PM  
Blogger rong said...

how do you think the AirMax Zength
AirMax 09
AirMax 180
AirMax 2003
AirMax 2006
AirMax 2009
AirMax 2010
AirMax 360
AirMax 87
AirMax 90
AirMax 91
AirMax 92
AirMax 93
AirMax 95
coach outlet
coach handbag
coach handbags
coach bag
coach bags
discount Oaklay sunglasses
cheap Ray Ban sunglasses
ugg boots
ugg boots discount
cheap ugg boots
classic ugg boots
ugg classic tall boots

7:24 PM  
Blogger rong said...

spyder
spyder jackets
spyder ski wear
Detroit Lions
Green Bay Packers
Houston Texans
Indianapolis Colts
Jacksonville Jaguars
Kansas City Chiefs
Miami Dolphins
Minnesota Vikings
New England Patriots
New Orleans Saints
herve leger
herve leger bandage dress
moncler
moncler jackets
moncler coats
moncler vest
moncler outlet
moncler Polo t shirt
ugg boots
polo boots
polo shoes

7:29 PM  
Blogger janewangleilei said...

You can have a look at it.
jordan shoes
Wow.
newest jordans
jordan 7
Wonderful!
air yeezy
jordan true flight
If you like,you can contact us.
jordan 3
jordan 4
We offer different styles.
jordan 1
jordan 2
Thanks.
jordan 5
jordan ajf shoes
There are cheap shoes to choose
nike footwear
jordan flight 45
Good quality with low price.
air jordan 2010
Air Jordan 2009
Enjoy it!
jumpman
nike trainers

10:43 PM  
Anonymous Anonymous said...

I also facing Oracle DBVERIFY that said there is a corrupt block, but RMAN say it is clean. I don't know why, but It is not easy to get oracle support confirmation about this. I choose to ignore DBVERIFY. But still wants some explanation...

2:37 AM  
Blogger Michael Jacksson said...

buy viagra
viagra online
generic viagra

7:27 AM  
Blogger guangming said...

wholesale nike shoesShop a great selection of authentic Nike shoes&Nike Air Max with reasonable price for the entire families at nike-shoes-max.com.nike shoes 100% quality guaranteed and smooth customer service.UGG Women's Classic Cardy Boots 5819 are available with colorful knit uppers (composed of a wool blend) and a sheepskin sock liner for extra comfort.ugg boots It is detailed with three oversized wood buttons, allowing it to be styled buttoned up, australia uggslouched down, slightly unbuttoned, or completely cuffed down. They have a light and flexible EVA outsole along with a suede heel guard provides durable wear all season long. That is why it is one of several styles that have been all time favorites with women.

8:07 PM  
Blogger Jason said...

of sports winter bootsin an unusual hero, the dyed red hair, left-handed players with that kind Ecco Casual Shoes

4:38 PM  
Blogger 2011bagnews said...

For those of you who are cheap true religion jeans not kdkjcxy0gkh familiar with the True Religion brand, established in 2002 True Religion has become well cheap true religion jeans for women known for their American made great fitting jeans. Key features to the jean include horseshoe-shaped patching on the back pockets, heavy contrast stitching, True Religion branded tabs, and zip fly. The jeans range in price from £150 - £320 cheap designer jeans so a sale is always good news.
True Religion jeans at sale discount true religion jeans price would make a great Christmas present for those who like to true religion brand jeans spend that little bit extra on a designer jean. The True Religion styles we are currently true religion brand jeans running sale prices on include the Nathan and Ricky.


True Religion is striking wholesale true religion jeans while the iron is hot as they plan to open 27 new stores in the US and one in Canada in fiscal 2010, which adds to the 28 stores they opened over the past year. These direct true religion wholesale to consumer stores are a key piece of True Religion's growth goals, as formerly they were sold mainly through the sales channels of high-end department stores and boutiques. At the end of last year, they had a total of just 70 stores, so there would seem to be plenty of room for growth, but a product like this does run the true religion jeans wholesale risk at a certain point of losing the "boutique appeal" and cache.

12:36 AM  
Blogger 2011bagnews said...

People that pick these sorts of ray ban wayfarer 2113 eyeglasses want people today to seem at their face. These eyeglasses qgdcxy0hcv also are available in a amount of completely different frame alternatives producing them a fantastic buy.Ray ban sunglasses also are available in aviator style. This ray ban wayfarer 2151 design is in among the rimless and oversized options. They possess a frame, lens, and all of people things, First produced by Ray-Ban in 1937, this sort of sunglasses has in the beginning gained recognition amid Naval ray ban 3016 aviators, thus, the name. ray ban 3029 These days, you can see Ray ban sunglasses on people today who are into completely different types of sports activities like golf, angling and driving.Ray ban eyeglasses are so referred to as for the reason that they polarize the mild horizontally. one of the best factor about Ray ban sunglasses is the reality that they seem no completely different from frequent sunglasses although they deflect sunlight to permit correct vision. but they are created to get sleek and stylish. ray ban 3132 The sizing with the lens does differ on this type providing people today a lot of completely different alternatives to choose from. They are available in a amount of completely different colours too that make them effortless to fixture having a desired wardrobe choice.

12:32 AM  
Anonymous viagra online said...

That is very good comment you shared.Thank you so much that for you shared those things with us.Im wishing you to carry on with ur achivments.All the best.

2:55 AM  
Anonymous Anonymous said...

It's Friday morning and I'm on my way away from San Francisco after a splendid week of OOW, good guys, a few beers, and a lot of tech talk.Cheap Soccer Shirts | Cheap Football Shirts | henry 12 arsenal jersey | messi jersey 10 argentina | fabregas jersey arsenal | david villa barcelona youth jersey | benzema soccer jerseys | cristiano ronaldo real madrid jersey | cheap rooney soccer jerseys | kaka soccer jersey | real madrid shirt | new fc barcelona jersey | argentina jersey 2012 | Brazil jerseys wholesale | cameroon jerseys wholesale | england jerseys sale

6:57 PM  
Blogger GuildWars2Items said...

Fear not that the life shall come to an end, but rather fear that it shall never have a beginning Sell RS Gold, What gets us into trouble is not what we don't know.It's what we know for sure that just ain't so Sell Runescape Gold, Life is like a hot bath. It feels good while you're in it, but the longer Sell RS Gold you stay in, the more wrinkled you get.

Would you write to please D3 Gold just yourself? Or others? Or yourself by writing for others Cheap D3 Gold? It takes strength to do what must be done when the work is unpleasant and uncomfortable D3 Gold Sale, And of what would you write: Of love? Hate? Fun? Misery? Life? Death?Nothing Everything?

1:25 AM  

Post a Comment

Links to this post:

Create a Link

<< Home