| Lesson 2 | Oracle RMAN purpose and features |
| Objective | Discuss the purpose and features of Oracle Recovery Manager in Oracle AI Database 26ai. |
Oracle Recovery Manager (RMAN) remains the current Oracle AI Database 26ai technology for physical database backup, restore, and recovery. It has not been replaced by a differently named utility. RMAN coordinates work with the target database, records backup metadata, validates files and backups, reports recoverability, and automates many repetitive protection tasks.
RMAN reduces avoidable manual work, but it does not design a recovery strategy by itself. A database administrator still chooses the recovery point objective, recovery time objective, destinations, retention policy, encryption approach, redundancy, and test schedule. RMAN then supplies a consistent framework for implementing and verifying those decisions.
Data Pump, Flashback Database, Data Guard, and cloud recovery services complement this framework. Data Pump moves logical data and metadata. Flashback features can reverse certain changes. Data Guard maintains standby databases. None of those capabilities makes a recoverable RMAN backup unnecessary when the protection design requires physical restore and media recovery.
RMAN understands Oracle datafile formats and recovery requirements. Unlike a generic file-copy tool, it can identify database blocks, skip blocks that have never been used in many backup operations, coordinate consistent online backups, and associate backup pieces with the database incarnation and checkpoint information needed during recovery. It can also select suitable backups and archived redo when executing a restore or recovery request.
Its central purpose is to protect the physical database. Depending on scope and configuration, RMAN can back up a complete container database (CDB), selected pluggable databases (PDBs), tablespaces, datafiles, the control file, the server parameter file, and archived redo logs. Active online redo log members are not ordinary RMAN backup input. Archived redo is what makes recovery beyond a datafile backup's checkpoint possible.
| Feature area | RMAN contribution | Administrator responsibility |
|---|---|---|
| Backup | Creates backup sets or image copies and records their metadata. | Select scope, frequency, destination, retention, and redundancy. |
| Validation | Reads database files or backup media and checks for corruption without necessarily producing a backup. | Review results, investigate errors, and test complete recovery procedures. |
| Restore and recovery | Restores physical files and applies redo to reach the requested recovery point. | Choose the recovery objective and verify the recovered database or PDB. |
| Maintenance | Crosschecks recorded files and identifies backups that are expired or obsolete. | Decide when deletion is safe and preserve required offsite or immutable copies. |
| Duplication | Creates a duplicate or standby database from backups or from an active source. | Prepare the auxiliary environment and validate the duplicate's intended use. |
RMAN metadata and automation reduce risk only when the surrounding design is correct. RMAN cannot know that a destination shares the same failure domain as the production database, that a retention policy is shorter than the business requires, or that encryption keys have not been copied offsite. It can report that a command completed, but that success does not establish that an application will open correctly after a regional outage.
RMAN also does not replace operating-system, network, storage, and cloud-service monitoring. A backup job can encounter capacity limits, inaccessible media, credential changes, or throttling outside the database. Operators should correlate RMAN output with those systems and investigate warnings even when the process returns usable output.
The strongest control is a documented recovery exercise that starts from a realistic failure scenario. The exercise should identify which control file, SPFILE, password file, wallet, catalog, backups, and archived logs are needed; measure restore and redo-application time; and verify the recovered service. This turns RMAN's feature set into evidence that the stated recovery objectives are attainable.
The rman executable is a client. It interprets commands and establishes sessions with the target database. The database server
performs the block-level work through channels. A channel is a database server session associated with a device type and the
resources required to read or write backup data. Channels can be allocated automatically from persistent configuration or explicitly for
a particular job.
| Component | Role | Required? |
|---|---|---|
| RMAN client | Accepts interactive commands or command files and sends work to database sessions. | Yes for direct RMAN operation. |
| Target database | Owns the files being protected and always stores RMAN repository records in its control file. | Yes. |
| Channel | Performs backup, restore, validation, and recovery I/O through DISK or SBT. |
Yes; RMAN can allocate it automatically. |
| Recovery catalog | Stores RMAN metadata in a schema located in a separate database and supports stored scripts and longer metadata history. | Usually optional; required when RMAN backs up a physical standby database. |
| Media management software | Implements the SBT interface for media such as tape or configured cloud object storage. | Only for an SBT destination. |
DISK and SBT are RMAN's supported device types, and disk is preconfigured as the default. SBT is an interface boundary:
RMAN supplies backup and restore requests, while a compatible media-management library controls the external destination. Oracle AI Database
26ai also provides native SBT libraries for supported OCI destinations. Native integration simplifies the stack, but it does not eliminate
credential, destination, lifecycle, security, or recovery-test requirements.
The RMAN repository is the complete set of metadata RMAN uses about the target database and its backups. Repository records always exist in the target control file. They describe backup pieces, image copies, archived logs, database incarnations, and persistent RMAN settings. This means a database can use RMAN without creating a recovery catalog.
A recovery catalog is an optional schema in another Oracle database; it is neither a backup location nor a directory of dump files. When the target is registered, RMAN synchronizes control-file metadata into that schema. A catalog can retain history beyond the control file's practical retention window, centralize metadata for multiple targets, and store reusable RMAN scripts. Catalog availability must itself be protected, but loss of a catalog does not change the physical contents of existing backup pieces.
Stored scripts require a recovery catalog. For environments without one, an administrator can place RMAN commands in a protected client-side command file and execute that file in batch mode. Oracle 26ai catalog resynchronization enhancements can use savepoints to reduce the need to repeat completed work after an interrupted resynchronization.
RMAN writes two principal physical backup formats. A backup set contains one or more backup pieces in an RMAN-specific format. Backup sets support features such as unused-block optimization, compression, encryption, and multiplexing where applicable. An image copy is a byte-for-byte copy of a datafile, control file, or archived log and can participate in an incrementally updated copy strategy.
| Choice | Useful characteristic | Important boundary |
|---|---|---|
| Backup set | Compact RMAN-managed format with optional compression and encryption. | Must be restored by RMAN before the contained files can be used. |
| Image copy | Physical file copy that can be switched into some recovery workflows. | Normally consumes space comparable to the source file. |
| Full backup | Contains every used block selected for the backup. | Does not serve as the parent of a level 1 incremental backup. |
| Incremental level 0 | Has full-backup content and establishes the base for later level 1 backups. | It is not the same operational category as a full backup. |
| Incremental level 1 | Backs up changed blocks relative to an eligible incremental parent. | Benefit depends on workload, change rate, storage, and restore design. |
Block change tracking can help RMAN locate changed blocks for incremental backups without scanning every block in every datafile. It can reduce incremental backup work, but it does not guarantee a fixed performance improvement. Backup design should be measured against the actual database, storage path, and recovery objective.
The CONFIGURE command stores persistent choices in the RMAN repository. These settings can define automatic channels, device types,
backup formats, control-file autobackups, encryption behavior, backup optimization, retention policy, and other defaults. SHOW ALL
displays the effective configuration. Persistent configuration makes scheduled jobs repeatable and reviewable; it does not make every default
correct for every recovery plan.
A control-file autobackup is especially valuable because it can also include the server parameter file when an SPFILE is in use. RMAN can locate an autobackup during certain disaster-recovery operations even when the repository in the current control file is unavailable. Administrators should still know where autobackups are written and confirm that the destination survives the failures covered by the plan.
RMAN commands can run interactively or from command files under a scheduler. Jobs should capture exit status and logs, alert on failure, and be reconciled with storage monitoring. A job that starts on schedule is not necessarily a usable backup; successful recovery testing is the stronger evidence.
RMAN validation reads files and performs block checks without necessarily creating backup output. Physical corruption checks occur during
many RMAN read operations. CHECK LOGICAL requests additional logical checks and can require more work. Validation findings can be
recorded in V$DATABASE_BLOCK_CORRUPTION, which helps an administrator locate affected files and blocks.
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
This command tests readability and performs logical checks on the selected database files and archived redo logs; it does not create a
recoverable backup. Validation also does not automatically repair corruption, prove that every application dependency is correct, or show
that the entire recovery procedure will meet the recovery time objective. Depending on the damage and available backups, RMAN can use
RECOVER BLOCK for eligible block media recovery, but the cause and broader impact still require investigation.
Oracle AI Database 26ai desupports Data Recovery Advisor and its LIST FAILURE, ADVISE FAILURE,
REPAIR FAILURE, and CHANGE FAILURE commands. Oracle documents no direct replacement. Current lessons should teach RMAN
validation, reporting, appropriate restore or recovery procedures, and diagnostic views rather than those legacy advisor commands.
A retention policy expresses how RMAN determines which backups are no longer needed to satisfy a configured recovery window or redundancy.
Backups beyond that requirement are obsolete. The REPORT OBSOLETE command reports them, while
DELETE OBSOLETE removes both the physical files and their repository records after confirmation or under scripted policy.
Expired means something different. CROSSCHECK compares repository records with the files currently visible to a
channel. If a recorded file cannot be found, RMAN can mark it EXPIRED. An expired backup is not necessarily old, and an obsolete
backup is not necessarily missing. Confusing these states can either waste storage or delete protection that is still required.
Backup optimization can skip certain files when RMAN determines that an identical eligible backup already exists on the same device type. It should be enabled only with a clear understanding of retention, media rotation, and disaster scenarios. It is an efficiency policy, not an independent copy of the data.
RMAN provides SHOW, LIST, and REPORT commands for different questions. SHOW examines persistent
configuration. LIST displays repository records such as backups and archived logs. REPORT evaluates conditions such as
obsolete backups, schema history, or files that need backup under a policy.
RMAN> SHOW ALL;
RMAN> LIST BACKUP SUMMARY;
RMAN> REPORT NEED BACKUP;
The last command depends on an applicable retention policy or requested criteria. These reports should feed operational review, but they do
not replace inspection of job logs, destination capacity, database alerting, and restore tests. Dynamic performance views such as
V$RMAN_STATUS, V$RMAN_BACKUP_JOB_DETAILS, and V$BACKUP_ASYNC_IO support current-job and performance analysis.
Recovery-catalog environments provide corresponding RC_* views for centralized history.
In RMAN terminology, restore retrieves physical files from backup sets or image copies. Recovery applies redo so the restored files reach a consistent or requested point. A recovery can be complete or point-in-time, and its scope can be the database, a PDB, a tablespace, or other supported units. The required procedure depends on what was lost, the available backups and redo, and whether the operation changes the database incarnation.
The DUPLICATE command builds another database for testing, reporting, development, or standby creation. It can use existing backups
or duplicate from an active source under supported conditions. Duplication is a controlled database creation workflow, not proof that the
primary database's own recovery plan has been exercised. Test environments also require masking, credential, encryption-key, and network
controls appropriate to the copied data.
Oracle Real Application Clusters (Oracle RAC), not the obsolete Oracle Parallel Server name, is the current clustered database technology. RMAN can protect an Oracle RAC database, but all instances belong to one database and share its physical database identity. Channel placement, archived-log accessibility, snapshot control-file location, and backup-destination visibility must be designed for the cluster.
Data Guard is a separate availability technology. A physical standby can participate in backup operations and can offload appropriate work, subject to configuration and licensing. Backup metadata must remain usable across the Data Guard environment. A recovery catalog is required when RMAN performs backups of a physical standby database.
For a multitenant database, RMAN understands CDB and PDB scope. A complete CDB backup protects the root, seed, and included PDBs. A backup of one PDB protects only that PDB's scope; it is not complete CDB protection. Recovery planning must include the root metadata, control file, SPFILE, archived redo, wallet or keystore material where applicable, and the PDB-specific recovery objectives.
The administrative privilege intended for backup and recovery is SYSBACKUP. It supports separation of duties and should normally
be used instead of exposing the broader SYSDBA privilege to routine backup operators. Oracle 26ai protects sensitive dictionary data in backups created while connected with SYSBACKUP. Authentication files, wallets, media-manager credentials, scripts, logs,
and backup destinations remain part of the security boundary.
RMAN can compress backup sets and encrypt backups. Compression can reduce stored bytes while consuming processing resources; the outcome depends on data and algorithm. Encryption protects backup confidentiality, but keys and wallet material must remain recoverable after a site-level failure. Neither feature should be enabled with an assumption of a universal performance benefit.
The command-line client is the authoritative RMAN interface. Oracle Enterprise Manager Cloud Control and supported cloud-service consoles can schedule or expose backup workflows, but they are optional layers rather than replacements for RMAN architecture. In managed and Autonomous services, Oracle may automate the underlying process and restrict direct customer commands. The service's documented responsibility model controls what the customer configures and tests.
RMAN provides an extensive set of physical protection capabilities, yet recoverability remains an end-to-end property. A sound plan combines correctly scoped backups, archived redo, protected configuration and encryption material, independent destinations, monitored jobs, documented procedures, and regular restore and recovery tests. The test should verify both technical database recovery and the application's ability to use the recovered result within the required time.
Lesson 2 establishes RMAN's feature map: client commands coordinate server sessions and channels; repository metadata tracks the work; backup sets and image copies store physical protection; configuration and scripts automate repeatable jobs; validation and reporting reveal conditions; and restore, recovery, and duplication act on the protected files. The next lesson examines these components in greater detail.