ITPub博客

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

RMAN Crosscheck Clause

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

RMAN Crosscheck Clause

Check whether backup pieces, proxy copies, or disk copies still exist in comparison to the control file's repository.

Syntax:

  CROSSCHECK
    { 
      { BACKUP [OF listObjList] 
      | COPY [OF listObjList] 
      | archivelogRecordSpecifier 
      } [maintQualifier [maintQualifier]...] 
    | recordSpec [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
    };

   listObjList::=
      [ DATAFILE datafileSpec [, datafileSpec]... 
      | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... 
      | archivelogRecordSpecifier 
      | DATABASE [SKIP TABLESPACE ['] tablespace_name [']
           [, ['] tablespace_name [']]...] 
      | CONTROLFILE
      | SPFILE
      ]...

   recordSpec::=
      { { BACKUPPIECE | PROXY } 
        { 'media_handle' [, 'media_handle']... 
        | primary_key [, primary_key]... 
        | TAG [=] ['] tag_name [']
        }
      | BACKUPSET primary_key [, primary_key]...
      | { CONTROLFILECOPY | DATAFILECOPY }
        { { primary_key [, primary_key]... 
          | 'filename' [, 'filename']...
          } 
        | TAG [=] ['] tag_name ['] [, ['] tag_name [']]...
        }
      | ARCHIVELOG
        { primary_key [, primary_key]... 
        | 'filename' [, 'filename']...
        }
      } 

Use RMAN Crosscheck to check that files are in place ready for a restore.
To validate a restore has worked, use the RMAN restore validate command.

Examples:

Assuming you have configured automatic channels:

RMAN> CROSSCHECK BACKUP;
RMAN> CROSSCHECK COPY;
RMAN> CROSSCHECK backup of database;
RMAN> CROSSCHECK backup of controlfile;
RMAN> CROSSCHECK archivelog all;

Query the media manager for the status of backup sets in a given date range:

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
RMAN> CROSSCHECK BACKUP DEVICE TYPE sbt COMPLETED BETWEEN '01-AUG-04' AND '31-DEC-04';

"Wealth heaped on wealth, nor truth nor safety buys,
The dangers gather as the treasures rise" - Samuel Johnson: The Vanity Of Human Wishes

Related Commands:

RMAN Restore Validate
RMAN CHANGE
- Update the status of a backup in the RMAN repository.
RMAN CONFIGURE
- Persistent RMAN settings.
RMAN DELETE
- Delete backups from disk or tape
RMAN LIST - List backups and copies
RMAN REPORT - Report backup status: database, files, backups
NLS_DATE_FORMAT parameter

Related Views:

 RC_BACKUP_FILES V$BACKUP_FILES  RMAN backups and copies in the repository.
 RC_BACKUP_PIECE V$BACKUP_PIECE  Backup pieces

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

上一篇: impdp语法
下一篇: RMAN Backup Clause
请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    87851