{"id":3828,"date":"2025-06-09T11:44:59","date_gmt":"2025-06-09T11:44:59","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=3828"},"modified":"2025-06-09T11:45:00","modified_gmt":"2025-06-09T11:45:00","slug":"oracle-rman-commands","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/oracle-rman-commands\/","title":{"rendered":"Oracle RMAN Commands"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A practical guide to essential <strong>Oracle RMAN (Recovery Manager)<\/strong> commands for performing database backups, recovery operations, maintenance tasks, validation, and cataloging. Commands are grouped by function for quick reference and are compatible with Oracle 11gR2 (11.2.0.4) and higher.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Show RMAN Settings<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SHOW ALL; -- Displays all current RMAN settings\nSHOW ARCHIVELOG DELETION POLICY; -- Shows archive log deletion policy\nSHOW ARCHIVELOG BACKUP COPIES; -- Number of archive log backup copies configured\nSHOW AUXNAME; -- Shows auxiliary database info\nSHOW BACKUP OPTIMIZATION; -- Shows if backup optimization is enabled\nSHOW CHANNEL; -- Displays normal and auxiliary channel configuration\nSHOW CONTROLFILE AUTOBACKUP; -- Indicates if control file autobackup is on\nSHOW CONTROLFILE AUTOBACKUP FORMAT; -- Shows control file autobackup format\nSHOW DATAFILE BACKUP COPIES; -- Number of backup copies for datafiles\nSHOW DEFAULT DEVICE TYPE; -- Disk or tape as default device\nSHOW RETENTION POLICY; -- Displays configured retention policy\nSHOW ENCRYPTION ALGORITHM; -- Displays current encryption algorithm\nSHOW ENCRYPTION FOR DATABASE\/TABLESPACE; -- Shows encryption status\nSHOW EXCLUDE; -- Tablespaces excluded from backup\nSHOW MAXSETSIZE; -- Maximum size for a backup set\nSHOW SNAPSHOT CONTROLFILE NAME; -- Path to snapshot control file\nSHOW COMPRESSION ALGORITHM; -- Displays current compression algorithm<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Backup Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>BACKUP CURRENT CONTROLFILE; -- Manual control file backup\nBACKUP TABLESPACE USERS INCLUDE CURRENT CONTROLFILE; -- Backs up tablespace + control file\nBACKUP SPFILE; -- Backs up server parameter file\nBACKUP NOT BACKED UP SINCE TIME 'SYSDATE-1' DATABASE PLUS ARCHIVELOG; -- Resumes interrupted backup\nBACKUP DATABASE FORCE; -- Forces backup even if identical files exist\nBACKUP DATABASE; -- Complete database backup\nBACKUP DATABASE PLUS ARCHIVELOGS; -- Backs up DB + all archived logs\nBACKUP ARCHIVELOG ALL; -- Archives all logs\nBACKUP DATAFILE 5 TAG dbfile_5_bkp; -- Backup a specific datafile with tag<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Catalog Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>CATALOG DATAFILECOPY '\/u01\/oracle\/users.bkp'; -- Adds user-managed file to RMAN\nCATALOG BACKUPPIECE 'ertt2lu4_1_1'; -- Adds specific backup piece to catalog\nCATALOG START WITH '\/backups\/source_bkp' NOPROMPT; -- Catalogs directory backups\nCATALOG RECOVERY AREA; -- Catalogs all files in recovery area<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Report Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>REPORT NEED BACKUP; -- Shows which files need backup\nREPORT SCHEMA; -- Displays all datafiles\nREPORT OBSOLETE; -- Shows obsolete backups based on retention policy<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">List Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>LIST BACKUP; -- Lists all RMAN backups\nLIST BACKUP BY FILE; -- Lists backup files individually\nLIST BACKUPSET; -- Lists backup sets only\nLIST COPY; -- Lists image copies only\nLIST BACKUPSET TAG 'full_database_backup'; -- Lists backups by tag\nLIST BACKUP OF DATABASE; -- Lists all DB + archived log backups\nLIST INCARNATION; -- Shows all DB incarnations\nLIST RESTORE POINT; -- Lists restore points<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Crosscheck Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>CROSSCHECK BACKUPSET; -- Crosscheck all backup sets\nCROSSCHECK COPY OF DATABASE; -- Crosscheck all database copies\nCROSSCHECK BACKUPSET 10, 12; -- Crosscheck specific backup sets\nCROSSCHECK BACKUPPIECE TAG = 'monthly_backup'; -- Crosscheck by tag\nCROSSCHECK CONTROLFILECOPY '\/backups\/control01.ctl'; -- Crosscheck control file copy\nCROSSCHECK BACKUP OF DATAFILE '\/u01\/oracle\/system01.dbf' COMPLETED AFTER 'SYSDATE-7'; -- Date-based crosscheck\nCROSSCHECK BACKUP; -- Crosscheck all disk\/tape backups<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Delete Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>DELETE BACKUP; -- Deletes archived logs + backups\nDELETE COPY; -- Deletes all image copies\nDELETE BACKUPPIECE 9; -- Deletes specific backup piece\nDELETE COPY OF CONTROLFILE LIKE '\/backups\/%'; -- Deletes specific control file copies\nDELETE BACKUP TAG='double_bkp_prod'; -- Deletes backups with specific tag\nDELETE BACKUP OF TABLESPACE SYSAUX DEVICE TYPE SBT; -- Deletes SBT backup of SYSAUX<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Change Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>CHANGE BACKUPSET 6 UNAVAILABLE; -- Marks a backup set as unavailable\nCHANGE BACKUPSET 6 AVAILABLE; -- Reverts status to available\nCHANGE BACKUP TAG 'initial_db_bkup' KEEP FOREVER; -- Archives a backup permanently\nCHANGE BACKUP TAG 'inital_db_backup' NOKEY; -- Reverts from archival to normal\nCHANGE BACKUPSET 12 KEEP UNTIL TIME 'SYSDATE+60'; -- Retains for 60 more days<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Validate Commands<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>VALIDATE BACKUPSET 5; -- Validates specific backup set\nVALIDATE DATABASE ARCHIVELOG ALL; -- Checks physical corruption\nVALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL; -- Checks logical corruption\nVALIDATE DATABASE; -- Validates all datafiles\nVALIDATE RECOVERY AREA; -- Validates recovery area\nVALIDATE SPFILE; -- Validates SPFILE<\/code><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>A practical guide to essential Oracle RMAN (Recovery Manager) commands for performing database backups, recovery operations, maintenance tasks, validation, and cataloging. Commands are grouped by function for quick reference and are compatible with Oracle 11gR2 (11.2.0.4) and higher. Show RMAN Settings Backup Commands Catalog Commands Report Commands List Commands Crosscheck Commands Delete Commands Change Commands [&hellip;]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-3828","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3828","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3828"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}