Oracle's Rman Management command detailed

First, the relevant query command

1.List database backed up by the current Rman

rman> list incarnation;

Rollup Queries: – If you have more than one backup file, use these two list commands to have a general understanding of the backup files.

1.1. List backup summary; – Overview of available backups

B means backup

A indicates that Archivelog, F represents full backup, 0,1,2 represents incremental level backup

A indicates that expired is available avaliable, X

This command can derive a number of similar commands, such as

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 let us have a whole, intuitive understanding of the existing backup files.

1.2.list backup by file;– listed by file type

Respectively: Data file list, archive log list, control file list, 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;

2. List of related documents information

List backup of {archivelog, controlfile, Database, datafile, SPFile, tablespace};

list backup of database; –full,incremental,tablespace,datafile

2.1 Server parameter file:

List backup of SPFile;

2.2 Control Files:

List backup of Controlfile;

2.3 Data files:

List backup of Datafle n,n,n,n;

2.4 Table Spaces:

List backup of tablespace tablespace_name;– table space corresponding to backup

2.5 Archive LOG:

List Backup of Archivelog {All, from, high, like, logseq, Low, SCN, sequence, time, until};

List backup of Archivelog all;

List backup of Archivelog until time ' sysdate-1′;

List backup of archivelog from sequence 10;

List backup of Archivelog until sequence 10;

List backup of Archivelog from SCN 10000;

List backup of Archivelog until SCN 200000;

List Archivelog from SCN 1000;

List Archivelog until SCN 2000;

List Archivelog from sequence 10;

List Archivelog until sequence 12;