Re: Oracle 10g - flashback database questions

premmehrotra_at_hotmail.com wrote:
> Yes, I probably live in a magical world, but most of the production
> systems I work
> are packaged applications where many users are accessing the
> application which
> behind the scene connects to database. Since different users are using
> the application,
> it is quite difficult to rollback everyone's work to a previous point
> in time because of a single user error. If someone makes
> a mistake, it may be better to undo some transaction using log miner
> rather than flashbacking the entire database. I don't remember ever
> being called for a point in time recovery in production environment to
> correct a user error, Well, that could be the type of environment I
> have been working on for last 15+ years. I have not been working in
> the same group, I have to change my company 5+ times so I have
> exposure to many types of envrionments.

The last time I flashed back a database was during a maintenance window when a DBA accidentally made a mistake: And I was that DBA.

Could I have gone for the backup tapes? Sure. Of course the maintenance window would have had to have been extended by an hour rather than seconds. Could I have used log miner? Yes. But still the maintenance windows would have closed long before I was done with the recovery.

A bit of insurance was worth it: Well worth it. And in a SarbOx world the small performance hit is well worth the price of admission.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)