oracle rman list 命令

- 日理万妓 2022-12-03 01:56 196阅读 0赞

list backup;
    list backup by file;
    
    list backup of datafile 1;
    list backup of datafile '/u01/app/oracle/oradata/epps/system01.dbf';
    list backup of tablespace users;
    list backup of database;
    list backup of controlfile;
    list backup of spfile;
    
    list backup of archivelog all;
    list backup of archivelog from scn 22727871375;
    list backup of archivelog until scn 22727813497;
    list backup of archivelog from scn 22727031113 until scn 22727268951;
    list backup of archivelog from logseq 25432;
    list backup of archivelog until logseq 25432;
    list backup of archivelog from logseq 25426 until logseq 25428;

list backup summary;
    list backup of database summary;
    list backup of tablespace users summary;
    list backup of datafile 9 summary;
    list backup of archivelog all summary;
    list backup of controlfile summary;
    list backup of spfile summary;
    
    list backup tag='WHOLE_COLDBACK';
    list backup recoverable;
    list backup device type disk;

list backupset;
    list backupset 59139;
    list backupset tage 'TAG20160811T000724'

list copy;
    list copy of datafile '/u01/app/oracle/oradata/epps/system01.dbf';
    list copy of tablespace 'SYSTEM';
    list copy of datafile 1,3,7;
    list copy of controlfile;
    list copy of spfile;
    list copy of database;
    
    list copy of archivelog all;
    list copy of archivelog like '%.log';
    list copy of archivelog from time 'sysdate-14';
    list copy of archivelog from time "to_date('2020-07-11','yyyy-mm-dd')";
    list copy of archivelog until time 'sysdate-7';
    list copy of archivelog from time 'sysdate-14' until time 'sysdate-7';
    list copy of archivelog from scn 10000;
    list copy of archivelog until scn 11000;
    list copy of archivelog from scn 10000 until scn 11000;
    list copy of archivelog from logseq 1330;
    list copy of archivelog until logseq 1340;
    list copy of archivelog from logseq 1330 until logseq 1340;
    
    list copy completed after 'sysdate -14';
    list copy completed before 'sysdate -7';
    list copy completed between 'sysdate -14' and 'sysdate-7';
    list copy tag=WHOLE_COLDBACK;
    list copy recoverable;
    list copy device type disk;

list expired backup;
    list expired backup summary;
    list expired backup of archivelog all summary;
    list expired backup by file;
    list expired backupset;
    list expired archivelog all;

list archivelog all;
    list backup by file;
    list incarnation of database;