ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN Report Clause

RMAN Report Clause

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-04-28 16:42:33 0 删除 编辑

RMAN Report Clause

Report backup status: database files, status of files and backups (obsolete or unrecoverable.)
The REPORT command performs more complex analysis than LIST.

Syntax:

   REPORT 
   { { NEED BACKUP [ { INCREMENTAL | DAYS } [=] integer 
                     | REDUNDANCY [=] integer 
                     | RECOVERY WINDOW OF integer DAYS)
                     ] 
     | UNRECOVERABLE
     } 
     reportObject 
   | SCHEMA [atClause] 
   | OBSOLETE [obsOperandList]
   }
   [ DEVICE TYPE deviceSpecifier [,deviceSpecifier]... ] 

   reportObject::=
     [ DATAFILE datafileSpec [, datafileSpec]... 
     | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... 
     | DATABASE [SKIP TABLESPACE ['] tablespace_name [']
                  [, ['] tablespace_name [']]...]
     ]

   atClause::=
     { AT TIME [=] 'date_string'
     | AT SCN [=] integer
     | AT SEQUENCE [=] integer THREAD [=] integer
     }

   obsOperandList::= 
     [ REDUNDANCY [=] integer | RECOVERY WINDOW OF integer DAYS | ORPHAN ]...

"Our Constitution is in actual operation; everything appears to promise that it will last; but in this world nothing is certain but death and taxes" - Benjamin Franklin.

Related:

CROSSCHECK - Check whether backup items still exist.
LIST
- List backups and copies
SET
- Settings for the current RMAN session.
SHOW
- Display the current configuration

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

上一篇: RMAN Delete
下一篇: RMAN Show clause
请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86430