Database Reference
In-Depth Information
Database recovery ought to be easy in your mind. You have
enough problems when your database has unexpectedly left
the building, and those problems should not be made worse
by a bad piece of database-backup-and-recovery software. RMAN makes recovery of your
database easy as long as you have crafted a solid backup and recovery strategy (discussed
in previous chapters). Additionally, the old adage that practice makes perfect very much
applies to database recoveries. So take some time and practice a recovery or two before you
have to deal with the real thing. All too often, people wait for disaster to strike rather than
learning what to do beforehand.
This chapter is about what to do when disaster strikes and you are under the gun to get
your backup restored. In this chapter, we will discuss the following topics:
■
RMAN database-recovery basics
■
Recovering a database in NOARCHIVELOG mode
■
Recovering a database in ARCHIVELOG mode
■
Recovering data files or tablespaces in ARCHIVELOG mode
■
Recovering a database using incomplete recovery
■
Using image copies to recover your database
■
Other recovery topics
The best way to really learn about backup and recovery is to do it—a lot. The exercises
in this chapter along with the examples of the various forms of recovery will certainly get
you on your way.
Exam objectives are subject to change at any time without prior notice and
at Oracle's sole discretion. Please visit Oracle's Training and Certification
website (
http://www.oracle.com/education/certification/)
for the
most current exam-objectives listing.
In this chapter and in Chapter 6, “Tuning and Monitoring RMAN and the
Automatic Diagnostic Workflow,” we have opted not to use a recovery
catalog in our examples. The functionality demonstrated is the same with
or without a recovery catalog. Where there are exceptions to this rule, we
will note them or provide additional examples.
Search WWH ::
Custom Search