Oracle Backup & Recovery 101 (Paperback)

by KENNY SMITH (Author) "Imagine, after many days of torrential rains, the river near your house rises and overflows its banks..." (more)
Key Phrases: standby control file, open database backup, current online redo log file, Recovery Manager, Total Time, Task Description Minutes (more...)

Editorial Reviews

Product Description
Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized entry-level book shows new DBAs various methods for backup and recovery--including Recovery Manager (RMAN). Includes hands-on exercises and end-of-chapter reviews to reinforce just-learned concepts.

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

See all Editorial Reviews

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.1 x 7.5 x 1.4 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.com Sales Rank: #602,293 in Books (See Bestsellers in Books)

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 (Maineville, OH United States) - See all my reviews

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

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

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!!