RMAN Recipes for Oracle Database 11g - A Problem-Solution Approach

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.
There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders:

• Lose that data and your company could fail.
• Lose that data and you could be out of a job.

Scared? You should be. But there's help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide:

• Demystifies the steps required to protect your business data
• Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations
• Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems
• Respects your time by providing example-based solutions, not endless reading material

When the pressure's on, you don't have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

List of contents

1. Introduction.- 2. Jump-Starting RMAN.- 3. Using the Flash Recovery Area.- 4. Using the RMAN Client.- 5. Configuring the RMANEnvironment.- 6. Using the Recovery Catalog.- 7. Backing up with RMAN.- 8. Maintaining RMAN.- 9. Scripting RMAN.- 10. Restoring the Controlfile.- 11. Performing Complete Recovery.- 12. Performing Incomplete Recovery.- 13. Performing Flashback Recovery.- 14. Handling Online Redo Log Failure.- 15. Copying, Moving, and Upgrading Databases.- 16. Tuning RMAN.- 17. Troubleshooting RMAN.- 18. Using a Media Management Layer.- 19. Using Enterprise Manager for Backup and Recovery.- 20. Oracle Database 11g New Features.

About the author

Darl Kuhn, an Oracle DBA and software developer with 18 years experience, is a senior DBA with Sun Microsystems. Before joining Sun, his work as a consultant ranged from database administration to custom application development. Darl is a coauthor of the Oracle RMAN Pocket Reference book, and has written several articles for Oracle Magazine. He is an affiliate professor at Regis University where he teaches Oracle courses for the graduate department of Computer Information Technology. For the past nine years, Darl has served as a volunteer DBA and developer for the Rocky Mountain Oracle Users Group. Darl has an MBA from Colorado State University and currently lives in Littleton, Colorado.

Sam Alapati is an Oracle DBA for the Boy Scouts of America, working at their national office in Los Colinas, Texas. Prior to this, Sam worked at Sabre, NBC as well as Oracle Corporation as a Senior Principal Consultant in New York City. Sam has previously published Expert Oracle9i Database Administration, Expert Oracle Database 10g Administration, Oracle Database 11g RMAN Recipes(with Darl Kuhn and Arup Nanda) and Oracle Database 11g New Features(with Charles Kim), all for Apress, as well as two Oracle Certified Professional (OCP) certification books for Oracle Press. Sam has been working with relational databases since 1985, starting with the Ingres database. Sam holds the OCP certification for Oracle DBAs as well as the HP-UX System Administrator certification.

Summary

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.

There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders:

 

• Lose that data and your company could fail.


• Lose that data and you could be out of a job.

 

Scared? You should be. But there's help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide:

 

• Demystifies the steps required to protect your business data


• Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations


• Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems


• Respects your time by providing example-based solutions, not endless reading material

 

When the pressure's on, you don't have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

Product details

• Authors: Sa Alapati, Sam Alapati, Sam R. Alapati, Dar Kuhn, Darl Kuhn, Arup Nanda
• Publisher: Apress
• Languages: English
• Product format: Paperback / Softback
• Released: 01.01.2007
• EAN: 9781590598511
• ISBN: 978-1-59059-851-1
• No. of pages: 670
• Dimensions: 191 mm x 37 mm x 235 mm
• Weight: 1238 g
• Illustrations: XXXI, 670 p.
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Application software; B, Database Management, database programming, Professional and Applied Computing, Oracle;Oracle 11g;database;database administration