RMAN--Report command

RMAN--Report command

用于查看RMAN做backup的相關內容：

01 report need backup e.g.
===========================
01.01 report need backup days 2 database;
 report need backup days 2 database skip tablespace 'SYSTEM','USERS'; --tablespace name must capitalization
 report need backup days 2 datafile 9,10;
 report need backup days 2 tablespace 'SYSTEM','USERS';
01.02 report need backup incremental 3 database;
01.03 report need backup redundancy 2 database;
 report need backup redundancy 2 database skip tablespace 'SYSTEM','USERS';
 report need backup redundancy 2 datafile 9,10;
 report need backup redundancy 2 tablespace 'SYSTEM','USERS';
01.04 report need backup recovery window of 2 days database;
 report need backup recovery window of 2 days database skip tablespace 'SYSTEM','USERS';
 report need backup recovery window of 2 days datafile 9,10;
 report need backup recovery window of 2 days tablespace 'SYSTEM','USERS';

=======================================================
02 report unrecoverable e.g.
=============================
02.01 report unrecoverable;
 report unrecoverable database;
 report unrecoverable datafile 1,3,9;
 report unrecoverable tablespace 'SYSTEM','USERS';

=========================================================
03 report schema e.g.
============================
03.01 report schema;
03.02 report schema at time 'sysdate-7';
 report schema at time "to_date('01/11/2004','MM/DD/YYYY')";
03.03 report schema at scn 100;
03.04 report schema at sequence=12 thread=1; --oracle 9i
 report schema at logseq=12 thread=1 --oracle 8i

====================================================
04 report schema e.g.
============================
04.01 report obsolete;
04.02 report obsolete redundancy 2;
04.03 report obsolete recovery window of 2 days;
04.04 report obsolete orphan ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29987/viewspace-51633/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29987/viewspace-51633/