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/,如需转载,请注明出处,否则将追究法律责任。