Oracle DBA Backup and Recovery Quick Reference (Prentice Hall PTR Oracle Series) [Paperback]

Charlie Russel (Author), Robert Cordingley (Author)

Book Description

Publication Date: September 26, 2003 | Series: Prentice Hall PTR Oracle Series

The single most important task of an Oracle DBA is ensuring the integrity and recoverability of the database. This requires a thorough understanding of backup and recovery concepts as well as the details of the various methods of performing backups and restoring the database or portions of it. In early versions of the Oracle database, the choice of tools provided by Oracle was relatively limited, but with Oracle 9i, the Recovery Manager (RMAN) provides a powerful and flexible tool to manage the availability and recoverability of the database. The earlier tools, including Export and Import, are still present and play an important role in any comprehensive backup and recovery plan. This book is a quick reference guide to Oracle DBA backup and recovery that provides complete coverage of all key concepts and tools.

Editorial Reviews

From the Back Cover

The fast, practical backup/recovery reference for every Oracle DBA!

If you're a working Oracle DBA, here's the Oracle backup/recovery reference you've been searching for--simple, straightforward, and incredibly easy to use! This book covers every type of Oracle backup, every major recovery scenario, and every technique and tool--including export/import, Rman, flash backup, mirror splitting, snapshotting, and more. Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute!

• Covers Oracle through Oracle10g
• Essential backup and recovery concepts
• Physical, logical, closed, open, consistent, and inconsistent backups
• Export/import procedures with exp/imp and data pumps
• Rman initial configuration, repository databases, and integration with tape-library managers
• User-managed backup options
• Step-by-step recovery procedures: media, tablespace, full, and point-in-time recovery

About the Author

CHARLIE RUSSEL has extensive system administration and Oracle DBA experience, specializing in combined Windows and UNIX environments. He is co-author of more than 20 books for IT professionals, including Microsoft Windows Server 2003 Administrator's Companion (Microsoft Press) and UNIX and Linux Answers! Certified Tech Support (IDG).

ROBERT CORDINGLEY is an Oracle DBA in Austin, Texas. Together, Russel and Cordingley have co-authored Oracle DBA Scripting Quick Reference and Oracle DBA SQL Quick Reference (Prentice Hall PTR).

See all Editorial Reviews

Product Details

• Paperback: 352 pages
• Publisher: Prentice Hall PTR (September 26, 2003)
• Language: English
• ISBN-10: 0131403044
• ISBN-13: 978-0131403048
• Product Dimensions: 8.9 x 6.3 x 0.9 inches
• Shipping Weight: 1.2 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #2,900,997 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4 of 5 people found the following review helpful:

4.0 out of 5 stars A Nice Memory Aid, October 30, 2003

By 

W Boudville (Terra, Sol 3) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: Oracle DBA Backup and Recovery Quick Reference (Prentice Hall PTR Oracle Series) (Paperback)

If you are an Oracle database administrator and you have a background as a unix or Microsoft sysadmin, then you might wonder why there is a need for an ENTIRE book on backup of Oracle's database. It is not that you doubt the need for a backup. But a whole book? In unix, you do a "man" on the backup command and you are shown a few screens of options. Likewise for restoring. Under Microsoft, a similar situation prevails. But unix and Microsoft are general purpose operating systems. An operating system is basically about file manipulation. In essence, a file is the atomic unit to the OS. So the backup and restore options are limited to the richness of this information.

But Oracle's database is a specialised and elaborate "operating system". The data is constrained and structured far more than files in a real OS. A backup can take advantage of this by offering hugely more options to you; a far more expressive set of commands to do a fine grained backup of fairly arbitrary subsets of the data. And of course, also with the restore.

This increased power comes at a price. Remembering all those darned options, especially the obscure, rarely invoked ones. Hence this book. Its value is strictly as a memory aid. You have to already understand what those options do, from Oracle's official documentation. The book uses a common flow chart style graph for the options, for easier use.