Recovery is the only thing you really really need to be able to do. As a DBA. You can mess lots of other stuff up - but get to where you need recovery and then discover that - you cannot - that is a really bad feeling.
Funny how small the world is. I was just reading this article about a disaster in Alaska with some data. I was going to write about that - but got interrupted. When I came back - there was a new article in my blog list so I glanced at it. It was from Howard Rogers - and it was about... recovery. And it referenced basically the same article (hosted on a different server). And it was from as far away from me as you can get and still be on this planet...
Read about Howard's nightmare here.
We've all had those nightmares happen to us at one point or another.
It is all about recovery.
Too bad Howard wasn't running 10g - flashback table T to before drop;
Too bad I didn't have a longer undo_retention (I do now...).
Too bad the Alaska Department of Revenue didn't test their backups.
Just hoping some people are "scared" now and - well - test their recovery capabilities. Because it is all about recovery. We can fix anything else anyone does wrong - but if you cannot recover - that is money, money down the drain...