Question: What do
I do to minimize the downtime when performing a database
recovery? I have a very large database and we cannot
be down for a long period of time when restoring a bas file
and rolling forward. What are some of the low downtime
options for recovering an Oracle database?
Answer: The best way to minimize
downtime, is to never be in a position to recover the
database. If your downtime costs exceed $100,000 per
minute, then triple mirroring your disks is a great way to
prevent data loss at the disk level (although you are still
at-risk from logical corruption, but this is quite rare).
Also, read my important notes on
Oracle failover approaches to recovery.
That, combined with a server that has redundant RAM and
CPU, and you are fully protected against a recovery, all at
the hardware level.
Other tools and techniques to use to minimize downtime for a recovery
- Frequent full hot backups:
This approach minimizes the time to apply archived redo
logs when performing a database recovery.
- Standby database: You can use
Data Guard, Streams, or GoldenGate replication to make a
current standby database for a fast failover.
- RAC: RAC only protects you
against instance failure, and you still have a common
database (and data files) to manage.
- Fast Recovery Area (FRA):
Oracle has the
flash recovery area for fast recoveries.
Oracle Training from Don Burleson
The best on site
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
is the registered trademark of Oracle Corporation.