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 :-))).

25 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  
Blogger 林磊 said...

2015-10-22leilei
celine bags
canada goose jackets
Coach Outlet Store Online
Canada Gooses Sale,Canada Gooses Jackets,Canada Gooses Coats,Canada Gooses Parka
Toms Outlet Shoes
Louis Vuitton Handbags Outlet Stores
coach outlet
oakley sunglasses cheap
Jordan Retro 13 Hot Sale
ugg boots
Abercrombie Store
Christian Louboutin Sale For Men And Women
Air Jordan 8
coach outlet online
michael kors uk
hollister uk sale
coach outlet online
Mont Blanc Pens
Louis Vuitton Outlet Online Shop
michael kors outlet online
louis vuitton handbags
cheap ugg boots
Coach Factory Outlet
timberland outlet
ralph lauren outlet
Coach Outlet Coach factory
Abercrombie kids - Official Site
michael kors outlet
Louis Vuitton Handbags Official Site
ralph lauren uk
cheap ugg boots
michael kors outlet clearance
true religion outlet
nike trainers
michael kors outlet

11:54 PM  
Blogger 林磊 said...

2015-10-22leilei
celine bags
canada goose jackets
Coach Outlet Store Online
Canada Gooses Sale,Canada Gooses Jackets,Canada Gooses Coats,Canada Gooses Parka
Toms Outlet Shoes
Louis Vuitton Handbags Outlet Stores
coach outlet
oakley sunglasses cheap
Jordan Retro 13 Hot Sale
ugg boots
Abercrombie Store
Christian Louboutin Sale For Men And Women
Air Jordan 8
coach outlet online
michael kors uk
hollister uk sale
coach outlet online
Mont Blanc Pens
Louis Vuitton Outlet Online Shop
michael kors outlet online
louis vuitton handbags
cheap ugg boots
Coach Factory Outlet
timberland outlet
ralph lauren outlet
Coach Outlet Coach factory
Abercrombie kids - Official Site
michael kors outlet
Louis Vuitton Handbags Official Site
ralph lauren uk
cheap ugg boots
michael kors outlet clearance
true religion outlet
nike trainers
michael kors outlet

12:01 AM  
Blogger 柯云 said...

2016-01-08keyun
louis vuitton purses
cheap toms shoes
ray bans
michael kors outlet
louis vuitton handbags
michael kors outlet clearance
oakley sunglasses
michael kors outlet
cheap oakley sunglasses
cheap toms
hollister clothing
north face
ray ban sunglasses outlet
coach outlet
cheap ugg boots
michael kors outlet sale
north face jackets
swarovski crystal
hollister kids
louis vuitton handbags
louis vuitton purses
ugg boots
uggs outlet
ugg boots sale
ralph lauren outlet
oakley sunglasses cheap
air force 1 trainers
gucci handbags
uggs for women
fitflop clearance
ugg outlet store
cheap toms
louis vuitton handbags
coach outlet store
discount ugg boots
ugg australia
air max 95
chanel outlet
chanel purses
nfl jerseys

11:53 PM  
Blogger oakleyses said...

oakley sunglasses, michael kors outlet, louboutin outlet, prada handbags, air max, burberry outlet, louis vuitton outlet, ray ban sunglasses, tory burch outlet, cheap uggs, michael kors outlet, michael kors outlet, chanel handbags, burberry outlet, oakley sunglasses, kate spade outlet, uggs outlet, oakley sunglasses cheap, prada outlet, longchamp handbags, gucci outlet, air max, louis vuitton, ray ban sunglasses, nike shoes, jordan shoes, nike free, polo ralph lauren, michael kors outlet, polo ralph lauren outlet, ray ban sunglasses, oakley sunglasses, michael kors outlet, christian louboutin, tiffany and co, louboutin, tiffany and co, rolex watches, longchamp outlet, louis vuitton outlet, longchamp handbags, ugg boots clearance, michael kors outlet online sale, uggs, ugg outlet, louis vuitton outlet stores, louboutin shoes, replica watches, louis vuitton handbags

4:49 PM  
Blogger oakleyses said...

vanessa bruno, air max, michael kors uk, coach outlet, michael kors, sac guess, true religion outlet, nike free pas cher, nike free, kate spade handbags, timberland, lululemon outlet online, michael kors outlet, north face, abercrombie and fitch, coach purses, ralph lauren, polo lacoste, oakley pas cher, north face, new balance pas cher, sac hermes, coach outlet store online, converse pas cher, longchamp, nike tn, air max pas cher, hollister, sac burberry, air max, michael kors pas cher, nike air force, hogan outlet, ray ban pas cher, louboutin, polo ralph lauren, true religion jeans, mulberry, sac longchamp pas cher, replica handbags, true religion outlet, nike blazer, vans pas cher, ray ban sunglasses, nike roshe, true religion jeans, nike roshe run pas cher, hollister, nike air max, air jordan

4:51 PM  
Blogger oakleyses said...

louboutin, nike roshe run, north face jackets, vans shoes, asics running shoes, new balance shoes, mcm handbags, iphone 6 cases, reebok outlet, air max, giuseppe zanotti, longchamp, oakley, nike trainers, soccer shoes, hollister, celine handbags, s6 case, insanity workout, baseball bats, wedding dresses, babyliss pro, north face outlet, hollister clothing store, soccer jerseys, p90x, beats by dre, ralph lauren, mac cosmetics, chi flat iron, iphone cases, ferragamo shoes, nike huaraches, valentino shoes, birkin bag, lululemon outlet, ghd, timberland boots, iphone 6s plus cases, abercrombie and fitch, instyler, nfl jerseys, bottega veneta, ipad cases, jimmy choo outlet, iphone 5s cases, mont blanc, herve leger, iphone 6s cases, iphone 6 plus cases

4:54 PM  
Blogger oakleyses said...

converse, pandora charms, toms shoes, barbour, moncler outlet, sac louis vuitton, swarovski, links of london, louis vuitton, barbour, moncler, canada goose, moncler, canada goose jackets, pandora charms, converse shoes, rolex watches, vans, supra shoes, moncler, ugg boots, abercrombie, ugg, marc jacobs, ugg pas cher, ugg, wedding dresses, pandora jewelry, sac lancel, air max, louis vuitton, sac louis vuitton, coach outlet store online, juicy couture, hollister, ugg, canada goose, canada goose, moncler, juicy couture outlet, thomas sabo, moncler, ray ban, louis vuitton uk, montre homme, moncler, gucci, canada goose outlet, pandora jewelry, canada goose, canada goose uk

4:56 PM  
Blogger Nike Free said...

nike air max 1
nike air max 95
nike free 4.0
nike store
christian louboutin online
christian louboutin outlet
mbt canada
mbt Shoes
fitflops shoes
fitflop sale
Kobe Shoes
Nike Huarache Nm
Red Bottom Shoes
red sole shoes
cheap jordans
jordan 11 legend blue
Jordan 11 Retro 72 10
jordan shoes
coach sale
coach outlet store
michael kors
michael kors bags
Michael Kors Sale
michael kors bracelet
michael kors tote
michael kors hamilton
lebron 12
jordans 11

7:26 PM  

Post a Comment

Links to this post:

Create a Link

<< Home