When working with Oracle databases, backup and recovery are critical responsibilities.
At the heart of these tasks is RMAN (Recovery Manager), the standard utility provided by Oracle.
In this article, we’ll explain how RMAN works, its key features, use cases, and basic command examples—with clear diagrams for beginners.
What Is RMAN?
RMAN (Recovery Manager) is a command-line utility provided by Oracle for managing backups and performing database recovery.
┌──────────────────────┐
│ Position of RMAN │
├──────────────────────┤
│ Official Oracle tool │
│ for backup and recovery │
└──────────────────────┘
Unlike SQL*Plus, RMAN allows block-level backup of datafiles, SPFILE, and control files, along with automatic management of archive logs and recovery operations.
Key Features and Benefits of RMAN
| Feature | Description |
|---|---|
| Official Oracle tool | Built-in, no additional license required |
| Block-level backup | Backs up only used blocks, making backups efficient |
| Archive log management | Can back up and delete archive logs automatically |
| Full recovery capability | Allows recovery using redo logs and archive logs |
| Automation support | Easy to integrate with shell scripts and scheduled jobs |
| Recovery catalog support | Enables centralized backup history management using a separate schema |
What RMAN Can Do (With Diagram)
┌────────────────────────────────────┐
│ RMAN Capabilities Overview │
├────────────────────────────────────┤
│ ✔ Full database backups │
│ ✔ Per-datafile backup │
│ ✔ Archive log backup and deletion │
│ ✔ Control file and SPFILE backup │
│ ✔ Incomplete recovery (time/SCN/log) │
│ ✔ Backup validation and restore │
└────────────────────────────────────┘
RMAN consolidates all backup and recovery operations into a single powerful tool.
Backup Modes Comparison
It’s recommended to use RMAN in ARCHIVELOG mode for full functionality.
| Mode | Backup Availability | Notes |
|---|---|---|
| NOARCHIVELOG mode | Offline only | Online backup is not possible |
| ARCHIVELOG mode | Online and offline | Backups can be taken without downtime |
RMAN Backup Example
Here is how to perform a full database backup using RMAN:
$ rman target /
RMAN> BACKUP DATABASE FORMAT '/backup/backup_%U.bkp';
Backup of archive logs and the control file:
RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;
RMAN> BACKUP CURRENT CONTROLFILE;
These commands can be scripted for scheduled execution.
Recovery Flow with RMAN (Diagram)
In the event of failure, RMAN allows the following recovery workflow:
┌──────────────────────┐
│ RMAN Recovery Flow │
├──────────────────────┤
│① Restore from backup │
│② Apply archive logs │
│③ Open the database │
└──────────────────────┘
Command example:
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;
You can also perform incomplete recovery (e.g., to a specific time or SCN).
RMAN Architecture and Recovery Catalog
By default, RMAN stores backup metadata in the control file. However, it can also use a Recovery Catalog, which is a dedicated schema in a separate database.
┌────────────────────────┐
│ Where RMAN stores metadata │
├────────────────────────┤
│ ・Control File │
│ ・Recovery Catalog (optional) │
└────────────────────────┘
Using a Recovery Catalog provides more durable metadata management, even if the control file is lost.
Requirements to Use RMAN
| Item | Details |
|---|---|
| Oracle version | Supported from Oracle 9i onward |
| ARCHIVELOG mode | Required for online backups and recovery |
| FRA (Fast Recovery Area) | Optional destination for RMAN backups; monitor disk space carefully |
| Parameter tuning | Consider setting CONTROL_FILE_RECORD_KEEP_TIME for history length |
Summary: RMAN Is Essential for Oracle DBAs
RMAN is an indispensable tool for secure, efficient Oracle database administration. While it may seem complex at first, learning RMAN enables you to:
┌────────────────────────────────────────┐
│ Benefits of Using RMAN │
├────────────────────────────────────────┤
│ ✔ Efficient, safe backups │
│ ✔ Fast and complete recovery │
│ ✔ Reduced manual effort via automation │
│ ✔ Reliable history with Recovery Catalog │
└────────────────────────────────────────┘
In future articles, we’ll dive into topics like incremental backups, multisection backups, and recovery catalog setup.
Bookmark this site and continue learning!
[reference]
9.2.2 RMAN Repository
コメント