Reader small image

You're reading from  Oracle Database 11g : Underground Advice for Database Administrators

Product typeBook
Published inApr 2010
PublisherPackt
ISBN-139781849680004
Edition1st Edition
Right arrow
Author (1)
April Sims
April Sims
author image
April Sims

April Sims is currently the Database Administrator at Southern Utah University and an Oracle Certified Professional: 8i, 9i, and 10g with a master's degree in Business Administration from the University of Texas at Dallas. Involved as a volunteer with the Independent Oracle Users Group for over 7 years, April is currently a Contributing Editor for the IOUG "SELECT" Journal. April is an annual presenter at Oracle OpenWorld, IOUG COLLABORATE, and numerous regional Oracle-related conferences.
Read more about April Sims

Right arrow

Recovery goals determine backup configuration


A successful RMAN implementation will include the formal definition of both backup and recovery goals. You could refer back to Chapter 5 for RTO and RPO as a starting point. Mean Time to Recover (MTTR) is another objective that will be touched on in this chapter.

MTTR (also known as fast-start checkpointing) is not enabled in 11g by default. It allows the database to recover (apply committed transactions, rollback uncommitted), which automatically occurs while bringing up a database after a crash or during an actual restore and recovery session. To enable this feature, the following database parameter is set to a non-zero number.

fast_start_mttr_target               integer     0

At the same time, reset the following database parameters back to zero:

LOG_CHECKPOINT_INTERVAL
LOG_CHECKPOINT_TIMEOUT
FAST_START_IO_TARGET

You should know from the previous chapters that faster checkpoints (synchronizing all the datafile headers, flushes data written to...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Oracle Database 11g : Underground Advice for Database Administrators
Published in: Apr 2010Publisher: PacktISBN-13: 9781849680004

Author (1)

author image
April Sims

April Sims is currently the Database Administrator at Southern Utah University and an Oracle Certified Professional: 8i, 9i, and 10g with a master's degree in Business Administration from the University of Texas at Dallas. Involved as a volunteer with the Independent Oracle Users Group for over 7 years, April is currently a Contributing Editor for the IOUG "SELECT" Journal. April is an annual presenter at Oracle OpenWorld, IOUG COLLABORATE, and numerous regional Oracle-related conferences.
Read more about April Sims