Introduction to Oracle rman commands

The following articles mainly describe the Oracle rman command. The main content of the following articles is a collection of Oracle rman commands found in an online warfare with good reputation: THE list command lists the backup information in the control file and Oracle RMAN recovery directory.

Is one of the most intuitive ways to understand all visible database backup files,

 
 

  
  
list incarnation;  
  
  
list backup summary;  
  
  
list backup of database summary;  
  
  
list backup of tablespace summary;  
  
  
list backup of datafile n,n summary;  
  
  
list archivelog all summary;  
  
  
list backup by file;  
  
  
list backup;  
  
  
list expired backup;  
  
  
list copy;  
  
  
list backup of spfile;  
  
  
list backup of controlfile;  
  
  
list backup datafile n,n,n;  
  
  
list backup tablespace tablespace_name;  
  
  
list backup of archivelog all;  
  
  
list backup of archivelog from scn ...;  
  
  
list backup of archivelog until scn ...;  
  
  
list backup of archivelog from sequence ..;  
  
  
list backup of archivelog until time 'sysdate-10';  
  
  
list backup of archivelog {all, from, high, like, logseq, low, scn, sequence, time, until};  
 
 

1. List the databases backed up by Oracle RMAN:

 
 

  
  
RMAN> list incarnation; 
 
 

Summary query: -- if there are many backup files, you can use these two list commands to have a general understanding of the backup files.

 
 

  
  
list backup summary; 
 
 

Overview available backups

B Indicates backup

A Indicates Archivelog, F indicates full backup, 0, 1, and 2 indicates incremental level backup.

A Indicates AVALIABLE and X indicates EXPIRED.

This command can derive many similar commands, such

 
 

  
  
list backup of database summary  
  
  
list backup of archivelog all summary  
  
  
list backup of tablespace users summary;  
  
  
list backup of datafile n,n,n summary  
 
 

These commands give us a comprehensive and intuitive understanding of the existing backup files.

 
 

  
  
list backup by file; 
 
 

List by file type

Data File List, archived log list, control file list, And SPFILE list

 
 

  
  
list backup; 
 
 

This command lists the details of an existing backup set.

 
 

  
  
list expired backup; 
 
 

List expired backup files

 
 

  
  
list copy; 
 
 

List copy files

 
 

  
  
list copy of database;  
  
  
list copy of controlfile;  
  
  
list copy of tablespace users;  
  
  
list copy of datafile n,n,n;  
  
  
list copy of archivelog all;  
  
  
list copy of archivelog from scn 10000;  
  
  
list copy of archivelog until sequence 12;   
 
 

The above content is an introduction to the Oracle rman command. I hope you will get something.