oracle rman常用命令 -- list

rman target sys/oracle@db01 catalog rman/rman@db01

RMAN> list backupset;
RMAN> list backup;
RMAN> list backup summary;
RMAN> list all script names;
RMAN> list archivelog all;
RMAN> list expired backup;
RMAN> list incarnation;
RMAN> reset database to incarnation 2;
RMAN> list backup by file;
RMAN> list backup of tablespace nick;

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

列出过期的备份文件
list expired backup;

列出copy文件
RMAN> list copy;

服务器参数文件
RMAN> list backup of spfile;

控制文件
RMAN> list backup of controlfile;

RMAN> list backup of datafile 1;

归档日志
RMAN> list backup of archivelog all;
RMAN> backup archivelog all;

RMAN> list backup of archivelog until time 'sysdate-1';
RMAN> list backup of archivelog until time 'sysdate-7';
RMAN> list backup of archivelog until time 'sysdate';

RMAN> list backup of archivelog until sequence=10;
RMAN> list backup of archivelog sequence=10;
RMAN> list backup of archivelog from sequence=4;
RMAN> list backup of archivelog from scn=1821289;
RMAN> list backup of archivelog until scn=1821289;
如果要恢复到此SCN，需要指定到下一个scn
RMAN> list backup of archivelog scn between 1821289 and 1834285;

RMAN> list archivelog from sequence=9;
RMAN> list archivelog until sequence=9;
RMAN> list archivelog from scn 1821317;
RMAN> list archivelog until scn 1821317;