ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN LIST

RMAN LIST

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

RMAN LIST

List the backups and copies recorded in the repository.

Syntax:

 LIST 
   { INCARNATION [OF DATABASE [['] database_name [']]] 
   | [EXPIRED]
     { listObjectSpec  
       [ maintQualifier | RECOVERABLE [untilClause] ]... 
     | recordSpec
     }
   };

 listObjectSpec::=
   { BACKUP [OF listObjectList] [listBackupOption]
   | COPY [OF listObjectList]
   | archivelogRecordSpecifier
   }

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

 listBackupOption::=
   [ [BY BACKUP] [VERBOSE]
   | SUMMARY
   | BY { BACKUP SUMMARY | FILE }
   ] 

Examples

RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
RMAN> LIST BACKUP SUMMARY;
RMAN> LIST INCARNATION;
RMAN> LIST BACKUP BY FILE;
RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;
RMAN> LIST COPY OF DATAFILE 1, 2, 3;
RMAN> LIST BACKUP OF DATAFILE 11 SUMMARY;
RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
RMAN> LIST BACKUPSET OF DATAFILE 1;

"I see no reason for recording the obvious" - Edward Weston

Related Commands:

BACKUP - Back up database files, archive logs, backups, or copies.
CHANGE
- Update the status of a backup in the RMAN repository.
CROSSCHECK
- Check whether backup items still exist.
DELETE
- Delete backups from disk or tape
REPORT
- Report backup status: database, files, backups
RESTORE
- Restore RMAN backups and copies.

Related Views:

 RC_BACKUP_SET    V$BACKUP_SET    Backup sets
RC_BACKUP_SPFILE V$BACKUP_SPFILE Server parameter files in backup sets
RC_BACKUP_FILES V$BACKUP_FILES RMAN backups and copies in the repository.
RC_BACKUP_PIECE V$BACKUP_PIECE Backup pieces Datafiles: RC_TABLESPACE V$TABLESPACE All tablespaces registered in the recovery catalog. RC_DATAFILE V$DATAFILE All datafiles registered in the recovery catalog RC_BACKUP_DATAFILE V$BACKUP_DATAFILE Datafiles in backup sets RC_DATAFILE_COPY V$DATAFILE_COPY Datafile image copies RC_PROXY_DATAFILE V$PROXY_DATAFILE Datafile backups created by proxy copy Control Files: RC_BACKUP_CONTROLFILE V$BACKUP_DATAFILE Control files in backup sets RC_PROXY_CONTROLFILE V$PROXY_DATAFILE Control file backups created by proxy copy RC_CONTROLFILE_COPY V$DATAFILE_COPY Control file copies on disk

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

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

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86425