Database Reference
In-Depth Information
Summary
In some ways, this is the most important chapter when it comes to RMAN overall. In previ-
ous chapters we have shown you that typical backup and recovery is usually not a very com-
plex task in RMAN. When things go wrong, however, RMAN can become a bit trickier. Of
course, things tend to go wrong just when the stress is the highest and the need to get your
database up and running is the highest.
To help you with these difficult moments and prepare you for the OCP exam, we covered
RMAN reporting, tuning, and monitoring. Reporting is quite important because you need to
be able to see what backups are available (for example, to determine what types of incomplete
recovery are actually available).
Tuning is important because you want your backups and your recoveries to go as fast as
possible. The longer they take, the more impact they have on the system. Of course, every-
one wants restores to go fast. That's where strategies like parallelism come in handy.
Monitoring is important too because you need to be able to look at backup or restore
operations as they are happening and determine if they are proceeding normally. Monitoring
gives you that ability. It's important to know what is normal for your backups and your
recoveries so that when the time comes, you will be able to understand what is not normal
and how deviant a statistic actually is from the norm. Then you can address the problem.
We have covered a lot of RMAN material and there is more to come. Questions on
RMAN will be a significant portion of your OCP exam, which is why we have really hit
it hard in this topic. Study it thoroughly, and practice backup and recovery (both RMAN
and user-managed) several times before you take your test. If you do so, we suspect you
will do well on your exam.
We also introduced you to the Fault Diagnosability Framework and workflow. This is
new in the Oracle Database 12
c
exam. If you are a new DBA or even an old pro, it is well
worth taking the time to learn this fairly new feature (since Oracle Database 11
g
) of Oracle.
Questions on this feature likely will appear on your exam.
Exam Essentials
Be able to use the
LIST
and
REPORT
commands.
Understanding the
LIST
and
REPORT
commands is very important to RMAN operations and to being successful on your OCP
exam. They allow you to review metadata contained within the database control file and
recovery catalog, understand backups that have been taken, and take corrective action
when certain conditions arise.
Be able to administer the RMAN environment.
Understanding how to administer
RMAN is quite important. Knowing how to use commands like
CATALOG
,
DELETE
, and
CROSSCHECK
is critical to properly administering the RMAN environment. These commands
will come in especially handy after disaster recovery when you need to get your database up
and running quickly.
Search WWH ::
Custom Search