Following is the RMAN command list mostly used during the rman backup and recovery operations. These rman commands can be executed at RMAN prompt, or within a RUN block.

The most important rman command is RMAN BACKUP command that is used to backup database files. While RMAN RECOVER command used to recover from database failues and apply redo log files from backup to update them. Before using RECOVER command you must use RESTORE command to restor database files from backup.

The rman DUPLICATE command is another RMAN command used to create duplicate or copy database to another machine using previous backups for checking backups or testing purpose.

CONNECT The rman CONNECT command establishs a connection between RMAN and a target Database, including auxiliary and recovery catalog databases.
CONFIGURE The rman CONFIGURE command configures RMAN settings. These settings apply to all RMAN sessions until changed or disabled.
SHOW The rman SHOW command display the current configuration settings.
SET Sets RMAN configuration settings for the duration of the RMAN session, such as allocated disk or tape channels. Persistent settings are assigned with CONFIGURE.
LIST The rman LIST command produce a detailed listing of backup sets or backup copies recorded in the target database control file or repository
REPORT The rman REPORT command performs detailed analyses of the content of the recovery catalog. For example, this command can identify which files need a backup to meet the retention policy or which backup files can be deleted.
BACKUP Performs an RMAN backup, with or without archived redo logs. Backs up datafiles, datafile copies, or performs an incremental level 0 or level 1 backup. Backs up an entire database, or a single tablespace or datafile. Validates the blocks to be backed up with the VALIDATE clause.
RESTORE The rman RESTORE command restore files from backup sets or from disk copies to the default or a new location.
RECOVER Performs a complete or incomplete recovery on a datafile, a tablespace, or the entire database. Can also apply incremental backups to a datafile image copy to roll it forward in time.
ALLOCATE CHANNEL RMAN ALLOCATE CHANNEL command establishs a channel, which is a connection between RMAN and a database instance.
CONVERT The rman CONVERT command converts data file formats for transporting tablespaces and databases across platforms.
DELETE The rman DELETE command deletes backups and copies, remove references to them from the recovery catalog, and update their control file records to status DELETED.
DUPLICATE The rman DUPLICATE command uses backups of the target database to create a duplicate or copy database that you can use for testing purposes or to create a standby database.
RUN The rman RUN command executes a sequence of one or more RMAN commands, which are one or more statements executed within the braces { and } of RUN. 
VALIDATE The rman VALIDATE command examine a backup set and report whether its data is intact. RMAN scans all of the backup pieces in the specified backup sets and looks at the checksums to verify that the contents can be successfully restored
ADVISE FAILURE The rman ADVISE FAILURE command displays repair options for the failure found.
REPAIR FAILURE Repairs one or more failures recorded in the automated diagnostic repository (ADR).
REGISTER DATABASE The rman REGISTER DATABASER command registers the target database in the recovery catalog.
UNREGISTER The rman UNREGISTER command unregisters a database from the recovery catalog.
CATALOG The rman CATALOG command adds information about file copies and user-managed backups to the repository.
CREATE CATALOG The rman CREATE CATALOG command creates the repository catalog containing RMAN metadata for one or more target databases. It is strongly recommended that this catalog not be stored in one of the target databases.
CROSSCHECK The rman CROSSCHECK command checks the record of backups in the RMAN repository against the actual files on disk or tape. Objects are flagged as EXPIRED, AVAILABLE, UNAVAILABLE, or OBSOLETE. If the object is not available to RMAN, it is marked UNAVAILABLE
CHANGE Changes the status of a backup in the RMAN repository. Useful for explicitly excluding a backup from a restore or recovery operation, or to notify RMAN that a backup file was inadvertently or deliberately removed by an operating system command outside of RMAN.
DROP DATABASE Deletes the target database from disk and unregister it.
SHUTDOWN Shuts down the target database from within RMAN. Identical to the SHUTDOWN command within SQL*Plus.
STARTUP Starts up the target database. This command has the same options and function as the SQL*Plus STARTUP command.
SQL Runs SQL commands that cannot be accomplished directly or indirectly using standard RMAN commands; for example, it can run sql ‘alter tablespace users offline immediate’; before restoring and recovering the USERS tablespace.
Creates transportable tablespace sets from backup for one or more tablespaces.

RMAN Command list will be updated soon.

Data Dictionary and Dynamic Performance Views

Control File V$ View

View Describes


Archived and unarchived redo logs


Control files in backup sets


Corrupt block ranges in datafile backups


Datafiles in backup sets


RMAN backups and copies in the repository.


Backup pieces


Archived logs in backups


Backup sets


Server parameter files in backup sets


Information about datafile copy corruptions


Databases registered in the recovery catalog (RC_DATABASE) or information about the currently mounted database (V$DATABASE)


Database blocks marked as corrupt in the most recent RMAN backup or copy


All database incarnations registered in the catalog


All datafiles registered in the recovery catalog


Datafile image copies


Historical information about online redo logs


Offline ranges for datafiles


Online redo logs for all incarnations of the database since the last catalog resynchronization


All redo threads for all incarnations of the database since the last catalog resynchronization


Recovery catalog resynchronizations


RMAN persistent configuration settings


All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations

The Recovery Catalog view start with ( RC_*) for example

V$ARCHIVED_LOG  --Control file view

RC_ARCHIVED_LOG --Recovery catalog view

Go to top
JSN Boot template designed by