Summary of Common commands in Oracle rman commands

About the Oracle rman command, I found the rman command set on a certain network a few days ago. The rman command set in the Oracle rman command has always been what I want to know and finally got a good introduction, so we will share it with you today.

I. Summary of list Common commands

THE list command lists the backup information in the control file and RMAN recovery directory, which 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 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.

1.1. list backup summary; -- Overview of 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.

The Oracle rman 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.

1.2.list backup by file; -- list by file type

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

1.3.list backup;

This command lists the details of an existing backup set.

1.4.list expired backup;

List expired backup files

1.5.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 find some gains.