list命令

可以用于查看对应文件的信息，backup,copy,archivelog等

list incarnation
===================================================
list incarnation;
list incarnation of database;
list incarnation of database 'ORA9I';

===================================================
list backup
===========================
list backup;
list backup of database;
list backup of tablespace 'SYSTEM','USERS';
list backup of datafile 1,3,7;
list backup of datafile 'e:oracleoradataora9isystem01.dbf','e:oracleoradataora9iusers01.dbf';
list backup of controlfile;
list backup of spfile;
list backup of archivelog all;
list backup of archivelog like '%.log';
list backup of archivelog like '%.log';
list backup of archivelog from time 'sysdate-14';
list backup of archivelog until time 'sysdate-7';
list backup of archivelog from time 'sysdate-14' until time 'sysdate-7';
list backup of archivelog from scn 10000;
list backup of archivelog until scn 11000;
list backup of archivelog from scn 10000 until scn 11000;
list backup of archivelog from logseq 135;
list backup of archivelog until logseq 139;
list backup of archivelog from logseq 135 until logseq 139;
list backup completed after 'sysdate -14';
list backup completed before 'sysdate -7';
list backup completed between 'sysdate -14' and 'sysdate-7';
list backup of archivelog time between "to_date('2009-06-24 08:00:00','yyyy-mm-dd hh24:mi:ss')" and "to_date('2009-06-24 13:00','yyyy-mm-dd hh24:mi:ss')";
list backup tag=WHOLE_COLDBACK;
list backup recoverable;
list backup device type disk;
list backup completed after 'sysdate-14' tag=WHOLE_COLDBACK device type disk recoverable;
===================================================
list copy example
===========================
list copy;
list copy of database;
list copy of tablespace 'SYSTEM','USERS';
list copy of datafile 1,3,7;
list copy of datafile 'e:oracleoradataora9isystem01.dbf','e:oracleoradataora9iusers01.dbf';
list copy of controlfile;
list copy of spfile;
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('07-11-2004','mm-dd-yyyy')";
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 135;
list copy of archivelog until logseq 139;
list copy of archivelog from logseq 135 until logseq 139;
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 copy completed after 'sysdate-14' tag=WHOLE_COLDBACK device type disk recoverable;

================================================
list backup summary
===========================
list backup summary;??
list backup of database summa