Oracle RMAN for Absolute Beginners

Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle’s Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the event that data loss occurs. It is often said that a database administrator’s #1 job responsibility is to be able to recover from data loss. If you’re new to the Oracle platform, or you’re new to database administration in general, you can hardly go wrong by making it your first priority to learn to backup and recover the database that has been entrusted into your hands.

This book is short and sweet at just 200 pages. Focus lies on the mainstream use cases. Recovery Manager, or RMAN as it is called, is a powerful and complex tool that can be intimidating at first. Author Darl Kuhn understands the need to focus on the core use cases, building your confidence in the tool, and in your ability to recover from lost database files, and even to recover your entire database should that become necessary.

Oracle RMAN for Absolute Beginners shows how to backup your database. That’s the first job. You’ll learn to backup the entire database, and to create incremental backups that in turn can speed restore and recovery operations. Then you’ll learn to recover from lost data files, lost redo log files, lost control files, and even to restore the entire database from scratch. You’ll even learn how to clone a database for development and test purposes by backing the database up on one system and restoring it onto another.

Author Darl Kuhn has a decade and a half of experience in writing about, and teaching Oracle Database backup and recovery. If you are newly responsible for an Oracle Database, you can hardly do better than to pick up a copy of Oracle RMAN for Absolute Beginners.

What you’ll learn

• Understand the different file types that are involved in backup and recovery.
• Perform essential configuration of Oracle Recovery Manager (RMAN).
• Backup all or part of a database, including pluggable and container databases
• Recover from one or more lost data files, including up to the entire database
• Recover from lost control files and redo log files
• Clone a database for testing and debugging
• Apply Data Pump for fast exports and imports

Who this book is for

Oracle RMAN for Absolute Beginners is aimed at newly-minted database administrators, and at experienced administrators who are new to the Oracle Database platform. Focus is on fulfilling a database administrator’s #1 job requirement: being able to recover from data loss.

Table of Contents

Chapter 1: Getting Started
Chapter 2: Files in Support of Backup and Recovery Operations
Chapter 3: User-Managed Backup and Recovery
Chapter 4: Configuring RMAN
Chapter 5: RMAN Backups and Reporting
Chapter 6: RMAN Restore and Recovery
Chapter 7: Handling Online Redo Log Failures
Chapter 8: Data Pump