ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN--Report command

RMAN--Report command

原创 Linux操作系统 作者:vongates 时间:2019-01-07 10:21:07 0 删除 编辑

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

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    47
  • 访问量
    23845