Roads ? - where we're going, we don't need roads ...
Life is dul without a hammer | ORA600
ORA600 content Content RSS
Oracle ORA600 News RRSS Oracle News RSS
ORA600 blog Blog RSS
ORA600 blog Blog Atom

User login

Life is dul without a hammer

I sometimes have to smile when I hear someone talking about best practises on backup and recovery. Don't get me wrong - they all make very valid points. The fact is that the real world is sometimes very different.

In the real world there is only one valid point - money.
In the real world, the IT departement is there to support the business and not the other way around. This sometimes means that IT budget is tight, resulting in all kinds of strange and funny things but ultimately may also - indirectly - lead to data loss.

RMAN is nice - but what if you're still running on an unsupported Oracle 7.3 on an old platform and a so very very tired hardware, all because there is no budget. Or what if you just blew all the IT budget on nice and shiny hardware and forgot to calculate that RMAN MML part for your backup solution. Or what if you do not have the luxury of a big tape library and still have to switch tapes by hand on each and every server - who is doing the tape management anyway ... it's a silly job ... but you better keep that person motivated and happy !

Most of the recovery cases I will cover here are the result of human error ... and those are sometimes the result of budget constraints.
The same goes for this case - the hammer case.
This was a recovery case where I actually went on site.
It was ooooold hardware – a mid ‘90’s RS6000 with a DAS storage cabinet using SCSI disks.

Remember the RS6000 F30, F50 and 220's - that will give you an idea. Oh while we are on memory lane - remember the time where you had to carry around 10 different scsi cables and terminators at all time.
I always had a bunch of scsi cables laying around in the trunk of my car - together with meters of ethernet coax cable, terminators, a couple RANs, db/de9/25 connectors, gender changers, null modem and parallel cables and of course the good old soldering iron and multimeter.
But I never ever carried a rubber hammer around !

So when entering the server room I immediately noticed this rubber hammer hanging on a small cord next to the storage cabinet – (naturally)I asked what it is was used for ?

Apparently, when the machine was rebooted or shutdown – the disks would cool down and their head(s) would stick to the platters.
So when they started the machine again, they would listen to the disks and once they heard the struggling sound of the heads trying to free themselves, they would hit the disks with the hammer.
That seemed to always get the job done Wink

What happened ? One of the disks had finally failed ........ Duh.

The disk had crashed while migrating AIX to a higher level - you know ... exportvg, migrate/reinstall os, importvg.
The mapping of the filesystems was quite simple - one JFS would map to one LV on one PV or disk. All disks/PVs belonged to one VG. No RAID. They had about 7 data PVs/scsi disks, and all database files where spread around those PV's.

So a disk had crashed, making it impossible to perform an importvg.
No problem - we have a backup - let's just make a new VG of the remaining 6 disks - and rebuild the database from scratch.

Their backup solution was a user per user export. Not a best practise.
And to top it off - the backup script was hardcoded. Not a best practise.
You know what's next right ? - a new user was added a couple of months before and the backup script was not altered accordingly.

Bad luck - but wait. The new user was sitting on that crashed disk in a seperate tablespace !

Now, we were able to replace the PCB on the SCSI disk and it would spin up ! (how lucky can you be)
So the actual data on the disk was still intact, but because the disk was once part of a VG, made by a logical volume manager (LVM), you couldn't just pop in the disk in a machine and see the data.
So it’s not like a FAT or NTFS filesystem on windows where you hook up a disk to the server and voila, there are your files - we had to get an expert on site who had to extract the datafiles from the disk, wading through all the physical partitions. This guy knew his stuff but I can still see him sitting there breaking a sweat.

Once we got the datafiles, they were orphaned from their database – so we used DUDE's heuristic scanner to get the data out of the datafiles into flatfiles. One of the senior developers then quickly identified which flatfile was which table and using sqlldr we were able to load the data back in. There were only a 120 tables or so.

Later on I wrote a routine that would allow us to identify deleted records within the base dictionary tables – this makes it possible to map objectid's to table/column/usernames even if the objects were dropped – very much like the FEDS tool.

Unloading without a SYSTEM tablespace is always time-consuming as one needs to identify the flat files. Without SYSTEM, there's no dictionary and without a dictionary there are no table/column names and datatypes.

In conclusion – if you see a hammer attached to a storage device ... Walk away.


when to take 100mg of viagra

efectos sildenafil 100mg viagra without prescription viagra e cialis generico [url=]viagra without a doctor prescription[/url] sildenafil sandoz 100 mg tabl. 8x

online casino real money singapore

slot games online for real money [url=]online roulette strategy red black[/url] northern ca indian casinos map casino x online

viagra generico soft tabs

viagra in malaysia online viagra without an rx say your doctor get viagra [url=]viagra without a doctor visit[/url] can you get immune to viagra

order viagra pills online

do need prescription buy viagra australia viagra without a doctor's prescription viagra for sale online cheap [url=]viagra without a doctor[/url] can you buy generic viagra store

viagra online without prescription- free shipping

order viagra australia viagra without a prescription legal order viagra online canada [url=]viagra without prescription[/url] ok take 100 mg viagra

cialis einfuhr deutschland

only now cialis attorneys [url=]generic cialis[/url] generic cialis quanto costa cialis 10 mg

cialis sale manila

order cialis online no prescription cialis without a doctor's prescription [url=]cialis without doctor[/url] cialis for sale online in canada

cialis online store

cialis at liquidation price [url=]buy cialis online[/url] buy cialis descuento de venta de cialis

how to order cialis online

buy cialis black online cialis without a doctor purchase discount cialis online [url=]cialis without a doctor's prescription[/url] cheapest cialis prescription

can you buy cialis canada

cheap cialis online pharmacy prescription cialis without prescription cialis pills toronto [url=]cialis without a prescription[/url] buy cheap cialis link online

viagra michigan

cost viagra nz [url=]online viagra[/url] generic viagra online women taking mens viagra

viagra softtabs

viagra kauf forum [url=]purchase viagra[/url] cheap viagra only for you viagra pill

buy cialis online no rx

cutting cialis pills in half cialis without a doctor's prescription cialis fake pills [url=]cialis without a doctor prescription[/url] cheap cialis paypal

no de can i take cialis

foro cialis [url=]cialis cheap[/url] generic cialis cialis 20mg tunisie

farmacia online comprar viagra

viagra lower price sildenafil 50 mg sandoz [url=]how do you get viagra in australia[/url] se puede comprar viagra generico en farmacias buy viagra dominican republic [url=]walgreens price for viagra[/url] buy viagra for female asda pharmacy viagra prices [url=]costco viagra price[/url] generic sildenafil citrate tablets buy viagra on the high street [url=]buy viagra in durban[/url] can cut viagra pill half buying viagra in tijuana [url=]sildenafil sante 50 mg[/url] best place buy sildenafil citrate buy viagra online from uk [url=]buy viagra over counter[/url] good site buy viagra can you buy viagra cvs [url=]acquisto viagra generico line[/url] cuanto sale una pastilla de viagra argentina how to buy viagra in ireland [url=]tab viagra 100mg[/url] buying cheap viagra online uk buy poppers viagra [url=]is viagra cheaper in canada[/url] viagra online bestellen viagra super force 100mg [url=]buy generic viagra next day delivery[/url]

compare prices viagra cialis

cheap legal cialis cialis cost cialis 2.5mg pills [url=]cialis without a doctor's prescription[/url] cheap cialis europe

viagra thailand buy

cialis for sale in nz cialis tablets cuanto sale el cialis [url=]cialis cost[/url] cialis cheap online

canadian pharmacy buy cialis professional

buy cialis online from uk cialis prices buy cialis online no prescription usa [url=]cialis without a doctor's prescription[/url] buy cialis in usa

viagra cialis for sale canada

buying viagra in hyderabad [url=]buy generic viagra[/url] viagra online ordonnance viagra en ligne

cialis for sale in usa

discount cialis online canada cialis coupon discount card for cialis [url=]cialis pills[/url] cialis description of pills

generic cialis complaints,

cialis prescribed online [url=]cialis canada[/url] generic cialis look there cialis sale buy

will 25 mg viagra work

generic viagra available walgreens viagra tablets generic viagra available over counter [url=]viagra prices[/url] viagra with blood pressure pills

how can i get viagra cash

cost of viagra 100mg pfizer [url=]buy viagra[/url] buy generic viagra vendite viagra

autocad for civil engineering students

autocad key gen autocad 2017 buy autocad 2013 [url=]autodesk autocad[/url] autocad 2013 software

autocad for android download apk

autocad 2012 32 bit serial number and product key autocad 2016 descargar autocad para android [url=]autocad download[/url] buy autocad cheap

buy cialis in india

cheap cialis lilly cialis 20 mg best price order cialis online safe [url=]cialis[/url] discount cialis no prescription

cialis 20mg what to expect

now toronto cialis cheapest [url=]buy cialis[/url] buy cialis online cialis cheap buy

cialis wholesale prices

cialis buy from india cialis sans ordonnance how to buy cialis online in australia [url=]cialis cost[/url] buy cialis no rx

viagra with online pharmacies

generic viagra vega 100mg [url=]buy generic viagra[/url] online viagra viagra buy uk no prescription

acheter viagra pas cher

viagra ou dhea [url=]buy viagra online[/url] viagra online viagra hong kong mannings

buy cheap 50 mg viagra

viagra en generique [url=]buy viagra online[/url] cheap viagra just try! dose viagra

retail price of viagra 50mg

viagra sildenafil sale [url=]generic viagra online[/url] viagra cheap online viagra no rx,

payday loans direct lender no teletrack

easy loans bad credit small money loans [url=]payday loans abilene tx[/url] direct loan lenders online personal loans [url=]payday loans oshawa[/url] cash advance jacksonville fl get loans [url=]cash advance huntsville al[/url] direct lenders for bad credit loans pay day advance [url=]ca payday loans[/url] 2500 dollar loan i need money right now [url=]personal loans near me[/url] cash loans usa quick loans bad credit [url=]online payday loans las vegas[/url] payday loans tallahassee max loan [url=]loan site[/url] easy loans bad credit payday loans online direct lender only [url=]right now loads[/url] bad credit direct payday lenders bad credit cash loans online [url=]same day payday loans for bad credit[/url] fast cash loans with bad credit take out loan [url=]direct lending loans[/url]

autocad 2013 student version

autocad 2017 ita download autocad download autocad 2012 download for mac [url=]autocad 2014[/url] autocad architecture 2017 product key

follow link gel viagra

es que para viagra [url=]buy viagra[/url] buy viagra viagra prices at costco

viagra generic from india

viagra gratuit [url=]buy viagra[/url] buy viagra online viagra sale shipped canada

mail order viagra india

is viagra free in scotland [url=]online viagra[/url] buy viagra online generic viagra purchase

viagra ebay australia

achat viagra risque [url=]viagra online[/url] buy viagra online viagra buy safe to

the best choice real viagra

people viagra who [url=]buy viagra[/url] online viagra generic viagra 5mg

autocad 15 student

autocad drawing software autocad 2016 descargar bloques de autocad gratis 3d [url=]autocad 2014[/url] autocad 2017 product key and serial number

extended use viagra

tomar viagra y alcohol [url=]buy viagra online[/url] buy viagra achat viagra risque

price of autocad 2017 software

precio de autocad 2011 autocad download free autocad autodesk 2017 download [url=]autocad 2012[/url] autocad 2017 product key serial number

viagra im internet einkaufen

shipping viagra to uk. [url=]viagra online[/url] viagra online cheapest viagra 100mg 50 cents

autocad cost estimation

autocad release 14 serial number autodesk autocad autocad per studenti [url=]auto cad[/url] autocad online jobs in dubai

autocad full version 2013

autocad map 3d 64 bit download autocad 2018 buy autocad uk [url=]autocad 2015[/url] autocad articles

code autocad 2017

autocad 2011 service pack 2 download autocad 2016 autocad architecture 2017 download [url=]autocad 2016[/url] autocad serial number

viagra 79

mexican viagra online [url=]buy viagra online[/url] buy viagra online algo similar al viagra

See DUDE primer for info

Get Support


Belgium :
Kurt Van Meerbeeck
ORA600 bvba
Cell : +32 495 580714

Denmark :
Michael Môller
Service & Support Manager
Miracle AS
E-mail :
Cell: +45 53 74 71 27

Latin America

Brazil :
Cell : +55 47 88497639


South Africa :
Kugendran Naidoo
NRG Consulting
Cell : +27 82 7799275