 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 10 - Ease of Administration
Create and Standardize
Monitoring and Administration Scripts
All DBAs have their own set of favorite Oracle administration and
monitoring scripts. They find them on the web, get them from
third-party books and trade them like bubble-gum cards. They then
tune, tweak and tailor them until they fit their own unique style of
administration.
It is highly recommended that database
administration units create a set of scripts for daily monitoring,
hot and cold backups, exports and common administrative activities.
This library of scripts can then be installed on each server
administered by the team. Personalizing the scripts should be highly
discouraged. Any modifications to the library can be reviewed during
team meetings. Assign a team member the responsibility of being the
script library owner. The script library owner will be responsible
for making all script modifications and installing the new scripts
on the supported servers.
Repeatable Processes
Repetition, even though it can be boring, is
the foundation for a high quality support environment. If the
scripts and administrative process worked correctly the first time,
chances are they will continue to work correctly in the future.
Documenting complex administrative processes
such as production to decision support database refreshes and
application upgrade activities will allow future iterations of these
activities to be executed more quickly and with less errors.
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
|
|