 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Checkpoint Not Complete
The log_checkpoint_timeout, log_checkpoint_interval
and fast_smart_mttr_target parameters come to the rescue. These parameters can be set to
decrease the time of instance recoveries.
It is important to note that these parameters
will not reduce the amount of data lost in certain database recovery
scenarios. If a lost or damaged archived or online redo log is
required as input to a database recovery, the amount of data lost
will be directly proportional to the amount of time that the lost
redo log was active. Since we now know that the size of the
archived redo logs determine how long the log will be active, the
larger the log the more data loss there will be!
Resizing Redo Logs
Now that we understand how to determine what
sizes our redo logs should be, let’s continue our discussion with
some information on how to resize them. Before we begin resizing our
redo logs, we need to review Oracle recommendations on redo log
groups and members.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
