• OCP-1Z0-053-V13.02-586题


    586.Consider the following command:

    Backup database plus archivelog delete input;

    How many backup sets would be created by this command if the following were true:

    Control-file auto backups were enabled.

    The size of backup sets was not restricted.

    One channel was allocated.

    A. 1

    B. 2

    C. 3

    D. 4

    E. 5

    Answer: D


    答案解析:


    RMAN> show all;


    RMAN configuration parameters for database with db_unique_name TESTDB are:

    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

    CONFIGURE BACKUP OPTIMIZATION OFF; # default

    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

    CONFIGURE CONTROLFILE AUTOBACKUP ON;

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

    CONFIGURE MAXSETSIZE TO UNLIMITED; # default

    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_testdb.f'; # default


    RMAN> Backup database plus archivelog delete input;



    Starting backup at 19-DEC-13

    current log archived

    using channel ORA_DISK_1

    channel ORA_DISK_1: starting archived log backup set

    channel ORA_DISK_1: specifying archived log(s) in backup set

    input archived log thread=1 sequence=10 RECID=5 STAMP=834597174

    input archived log thread=1 sequence=11 RECID=6 STAMP=834597417

    channel ORA_DISK_1: starting piece 1 at 19-DEC-13

    channel ORA_DISK_1: finished piece 1 at 19-DEC-13

    piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/o1_mf_annnn_TAG20131219T163657_9c5d1bn3_.bkp tag=TAG20131219T163657 comment=NONE

    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

    channel ORA_DISK_1: deleting archived log(s)

    archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/archivelog/2013_12_19/o1_mf_1_10_9c5csl13_.arc RECID=5 STAMP=834597174

    archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/archivelog/2013_12_19/o1_mf_1_11_9c5d19cn_.arc RECID=6 STAMP=834597417

    Finished backup at 19-DEC-13


    Starting backup at 19-DEC-13

    using channel ORA_DISK_1

    channel ORA_DISK_1: starting full datafile backup set

    channel ORA_DISK_1: specifying datafile(s) in backup set

    input datafile file number=00001 name=/u01/app/oracle/oradata/testdb/system01.dbf

    input datafile file number=00002 name=/u01/app/oracle/oradata/testdb/sysaux01.dbf

    input datafile file number=00005 name=/u01/app/oracle/oradata/testdb/example01.dbf

    input datafile file number=00003 name=/u01/app/oracle/oradata/testdb/undotbs01.dbf

    input datafile file number=00004 name=/u01/app/oracle/oradata/testdb/users01.dbf

    channel ORA_DISK_1: starting piece 1 at 19-DEC-13

    channel ORA_DISK_1: finished piece 1 at 19-DEC-13

    piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/o1_mf_nnndf_TAG20131219T163703_9c5d1j8c_.bkp tag=TAG20131219T163703 comment=NONE

    channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05

    Finished backup at 19-DEC-13


    Starting backup at 19-DEC-13

    current log archived

    using channel ORA_DISK_1

    channel ORA_DISK_1: starting archived log backup set

    channel ORA_DISK_1: specifying archived log(s) in backup set

    input archived log thread=1 sequence=12 RECID=7 STAMP=834597550

    channel ORA_DISK_1: starting piece 1 at 19-DEC-13

    channel ORA_DISK_1: finished piece 1 at 19-DEC-13

    piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/o1_mf_annnn_TAG20131219T163911_9c5d5hlk_.bkp tag=TAG20131219T163911 comment=NONE

    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

    channel ORA_DISK_1: deleting archived log(s)

    archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/archivelog/2013_12_19/o1_mf_1_12_9c5d5g7r_.arc RECID=7 STAMP=834597550

    Finished backup at 19-DEC-13


    Starting Control File and SPFILE Autobackup at 19-DEC-13

    piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/autobackup/2013_12_19/o1_mf_s_834597553_9c5d5lz1_.bkp comment=NONE

    Finished Control File and SPFILE Autobackup at 19-DEC-13


    RMAN> list backup;



    List of Backup Sets

    ===================



    BS Key  Size       Device Type Elapsed Time Completion Time

    ------- ---------- ----------- ------------ ---------------

    5       32.68M     DISK        00:00:02     19-DEC-13      

            BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20131219T163657

            Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/o1_mf_annnn_TAG20131219T163657_9c5d1bn3_.bkp


      List of Archived Logs in backup set 5

      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

      ---- ------- ---------- --------- ---------- ---------

      1    10      736975     19-DEC-13 759987     19-DEC-13

      1    11      759987     19-DEC-13 760624     19-DEC-13


    BS Key  Type LV Size       Device Type Elapsed Time Completion Time

    ------- ---- -- ---------- ----------- ------------ ---------------

    6       Full    1.17G      DISK        00:01:59     19-DEC-13      

            BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20131219T163703

            Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/o1_mf_nnndf_TAG20131219T163703_9c5d1j8c_.bkp

      List of Datafiles in backup set 6

      File LV Type Ckp SCN    Ckp Time  Name

      ---- -- ---- ---------- --------- ----

      1       Full 760633     19-DEC-13 /u01/app/oracle/oradata/testdb/system01.dbf

      2       Full 760633     19-DEC-13 /u01/app/oracle/oradata/testdb/sysaux01.dbf

      3       Full 760633     19-DEC-13 /u01/app/oracle/oradata/testdb/undotbs01.dbf

      4       Full 760633     19-DEC-13 /u01/app/oracle/oradata/testdb/users01.dbf

      5       Full 760633     19-DEC-13 /u01/app/oracle/oradata/testdb/example01.dbf


    BS Key  Size       Device Type Elapsed Time Completion Time

    ------- ---------- ----------- ------------ ---------------

    7       19.00K     DISK        00:00:00     19-DEC-13      

            BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20131219T163911

            Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/o1_mf_annnn_TAG20131219T163911_9c5d5hlk_.bkp


      List of Archived Logs in backup set 7

      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

      ---- ------- ---------- --------- ---------- ---------

      1    12      760624     19-DEC-13 760709     19-DEC-13


    BS Key  Type LV Size       Device Type Elapsed Time Completion Time

    ------- ---- -- ---------- ----------- ------------ ---------------

    8       Full    9.36M      DISK        00:00:02     19-DEC-13      

            BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20131219T163913

            Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB/autobackup/2013_12_19/o1_mf_s_834597553_9c5d5lz1_.bkp

      SPFILE Included: Modification time: 19-DEC-13

      SPFILE db_unique_name: TESTDB

      Control File Included: Ckp SCN: 760721       Ckp time: 19-DEC-13

  • 相关阅读:
    1048. Find Coins (25)
    return view 详解 MVC
    EF Power Tool 代码生成器 反向生成
    对新数据库使用 Code First
    一个成熟的网站的架构设计应该是这样的
    公司业务的设计思想感悟
    请给奋斗中的男人们一次机会
    大话西游感悟
    充满恶意的单词
    lisp的解释器
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316251.html
Copyright © 2020-2023  润新知