OCP认证考试指南(1ZO-063) Oracle Database 12c高级管理
上QQ阅读APP看书,第一时间看更新

4.4.1 使用LIST命令

LIST命令显示仓库中的备份集和映像副本的信息,也可以显示仓库目录中存储的脚本的内容。下例显示备份的简要信息,然后列出存储脚本名称:

        RMAN> list backup summary;

        starting full resync of recovery catalog
        full resync complete
    List of Backups
    ===============
    Key  TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
    ---  -- -- - ----------- --------------- ------- ------- ---------- ---
    786  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    787  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    788  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    789  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    790  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    791  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    792  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    793  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    794  B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T012351
    . . .
    1546 B  A  A DISK        25-FEB-14       1       1       YES   SAVE1YR
    1559 B  F  A DISK        25-FEB-14       1       1       YES   SAVE1YR
    1583 B  F  A DISK        25-FEB-14       3       1       YES   TAG20140225T101644
    1584 B  F  A DISK        25-FEB-14       1       1       YES   TAG20140225T101644

        RMAN> list script names;

        List of Stored Scripts in Recovery Catalog

            Scripts of Target Database RPT12C

              Script Name
              Description
              --------------------------------------------------------
              local_backup_db

            Global Scripts

              Script Name
              Description
              --------------------------------------------------------
              backup_ts

              global_backup_db

        RMAN>

LIST命令的另一个变体是LIST FAILURE,此命令显示数据库故障;第6章将介绍LIST FAILURE、ADVISE FAILURE和REPAIR FAILURE。