Oracle Backup & Recovery 101 [Paperback]

Kenny Smith (Author)

Book Description

ISBN-10: 0072194618 | ISBN-13: 978-0072194616 | Publication Date: March 1, 2002 | Edition: 1st

This text introduces various methods for Oracle database backup and recovery. It includes backup and recovery exercises that can be practised at home which allows the reader to test their skills. Hands-on troubleshooting exercises show common issues that can occur during the backup and recovery process and chapter review questions and answers test reader's knowledge and comprehension.

Editorial Reviews

From the Back Cover

Learn to Protect Data in an Oracle Database

Oracle Backup and Recovery 101 explains, step-by-step, how to manage database backup and recovery via physical file operations and logical data operations. The book also teaches you how to perform server-managed backup and recovery using Oracle Recovery Manager (RMAN). Officially authorized by Oracle Corporation, this hands-on guide shows you everything you need to know to implement a basic backup and recovery plan for your Oracle database and includes full details on setting up a small sample database so you can practice the tasks covered throughout the book.

• Handle user-managed physical database restore and recovery using an offline (cold) backup and archive logs
• Perform an online (hot) backup while the database is open
• Copy and clone an Oracle database for development and testing
• Create a standby database for high availability
• Perform tablespace recovery on a database using transportable tablespaces
• Analyze the online redo log file to find logical corruption
• Use Recovery Manager (RMAN) to simplify backup and recovery

About the Author

Kenny Smith (Duluth, GA) is an Oracle Certified Professional DBA and Senior Consulting DBA with Ajilon, LLC. He is experienced in computer applications engineering specialising in client-oriented relational database solutions on Windows and UNIX, has 7 years of C experience, and 9 years of Oracle, SQL, PL/SQL, UNIX and Windows development. Kenny has written numerous articles for Oracle and Profit Magazines as well as multiple industry journals. He presents at many Oracle conferences, including IOUG-A, UKOUG, and Oracle OpenWorld.

Product Details

• Paperback: 487 pages
• Publisher: McGraw-Hill/OsborneMedia; 1st edition (March 1, 2002)
• Language: English
• ISBN-10: 0072194618
• ISBN-13: 978-0072194616
• Product Dimensions: 9.3 x 7.6 x 1.2 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #573,106 in Books (See Top 100 in Books)
  • #100 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars A must have book for the production DBA, January 7, 2003

By 

Mark A. Loftin - See all my reviews

This review is from: Oracle Backup & Recovery 101 (Paperback)

Oracle backup and recovery can be very complex. The standard Oracle documentation is hard to follow and missing examples and scenarios. I've read this book cover to cover, and the authors have done an excellent job at capturing the information you need to know to backup and recover your Oracle database. The Linux discussions are applicable to any Unix platform as well. This book is a great reference to have before disaster strikes.

4 of 5 people found the following review helpful:

3.0 out of 5 stars Not for beginners - too many mistakes and typos, October 17, 2002

By 

"maxnata" (San Mateo, CA United States) - See all my reviews

This review is from: Oracle Backup & Recovery 101 (Paperback)

I would rate this book 5 stars for the material. But, gosh, is there any Oracle book without mistakes? When would authors and publishes care enough to eliminate them, or at least minimise them? Even errata contains only about 50% of necessary corrections - after 6 months from being published.
What is the value of instructions if you can't follow them?
If you know how to correct them by yourself, then you can buy this book, otherwise it would be another pain.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Excellent book!!, October 14, 2005

By 

Cool Jr. DBA (Detroit, MI USA) - See all my reviews

This review is from: Oracle Backup & Recovery 101 (Paperback)

I think that this book is excellent. Backup and recovery can be hard to understand at times, especially for those who are new to it. It is a great book that is all hands on, and that's the way you learn B/R, not just by reading. If you have a little bit of knowledge of B/R then this book will really help you a lot. I know people complained about the typos, but that is not that big of an issue, plus they already have an errata out for it. The only downside I guess is that everything is done using Oracle 8i and some commands are different. But if you combine this book with the Oracle9i Backup and Recovery documentation then you're all set! I think it explains things very well and makes you do things so you can see what exactly is going on. I would definitely recommend this book to anyone who has a little knowledge of Oracle B/R but would like to put that knowledge into practice. I want to give it 4.5 stars because of the minor typos and using 8i, but can't :) BUY THE BOOK!
Good Luck!!