OCP 1Z0 052 82

来源:互联网 发布:程序员的数学2pdf 编辑:程序博客网 时间:2024/05/22 06:44
82. You are managing an Oracle Database 11g database with the following backup strategy: 
1) On Sunday, an incremental level 0 tape backup is performed. 
2) Monday through Saturday, a cumulative incremental level 1 tape backup is performed. 
Which two statements are true regarding the backups performed? (Choose two.) 
A.The backup performed in step 1 backs up all blocks that have ever been in use in the database. 
B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.  
C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup. 
D.The  backup  performed  in  step  2  backs  up  all  blocks  that  have  changed  since  the  most  recent 
incremental backup at level 1. 
Answer: AB

A 没问题 level 0 备份所有数据
B 说法不精确

Incremental backups at level 1 copy only images of blocks that have changed since a previous incremental backup. Level 1 backups can be cumulative, in which case all blocks changed since the most recent level 0 backup are included, or differential, in which case only blocks changed since the most recent level 0 or level 1 incremental backup are included.  

RMAN> list backup;




List of Backup Sets
===================




BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    9.36M      DISK        00:00:01     14-JUN-14
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T150602
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\02PAQV2R_1_1
  SPFILE Included: Modification time: 14-JUN-14
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 1387835      Ckp time: 14-JUN-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  1.11G      DISK        00:01:41     14-JUN-14
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T161946
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\03PAR3D3_1_1
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1391057    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_9S5MLC2X_.DBF
  2    0  Incr 1391057    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_9S5MLC4W_.DBF
  3    0  Incr 1391057    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_9S5MLC6T_.DBF
  4    0  Incr 1391057    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_USERS_9S5MLC9R_.DBF
  5    0  Incr 1391057    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_EXAMPLE_9S5MPS1Y_.DBF
  6    0  Incr 1391057    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_TS_TEST_9S5NNK0Z_.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Incr 0  9.36M      DISK        00:00:02     14-JUN-14
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T161946
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\04PAR3GC_1_1
  SPFILE Included: Modification time: 14-JUN-14
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 1391094      Ckp time: 14-JUN-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Incr 0  1.11G      DISK        00:01:38     14-JUN-14
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T162138
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\05PAR3GI_1_1
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1391106    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_9S5MLC2X_.DBF
  2    0  Incr 1391106    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_9S5MLC4W_.DBF
  3    0  Incr 1391106    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_9S5MLC6T_.DBF
  4    0  Incr 1391106    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_USERS_9S5MLC9R_.DBF
  5    0  Incr 1391106    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_EXAMPLE_9S5MPS1Y_.DBF
  6    0  Incr 1391106    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_TS_TEST_9S5NNK0Z_.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  9.36M      DISK        00:00:01     14-JUN-14
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T162138
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\06PAR3JS_1_1
  SPFILE Included: Modification time: 14-JUN-14
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 1391149      Ckp time: 14-JUN-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Incr 1  616.00K    DISK        00:00:59     14-JUN-14
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T162610
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\07PAR3P2_1_1
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 1391617    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_9S5MLC2X_.DBF
  2    1  Incr 1391617    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_9S5MLC4W_.DBF
  3    1  Incr 1391617    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_9S5MLC6T_.DBF
  4    1  Incr 1391617    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_USERS_9S5MLC9R_.DBF
  5    1  Incr 1391617    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_EXAMPLE_9S5MPS1Y_.DBF
  6    1  Incr 1391617    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_TS_TEST_9S5NNK0Z_.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Incr 1  9.36M      DISK        00:00:01     14-JUN-14
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T162610
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\08PAR3R4_1_1
  SPFILE Included: Modification time: 14-JUN-14
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 1391641      Ckp time: 14-JUN-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 1  72.00K     DISK        00:00:55     14-JUN-14
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T162841
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\09PAR3TQ_1_1
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 1391680    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_9S5MLC2X_.DBF
  2    1  Incr 1391680    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_9S5MLC4W_.DBF
  3    1  Incr 1391680    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_9S5MLC6T_.DBF
  4    1  Incr 1391680    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_USERS_9S5MLC9R_.DBF
  5    1  Incr 1391680    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_EXAMPLE_9S5MPS1Y_.DBF
  6    1  Incr 1391680    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_TS_TEST_9S5NNK0Z_.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 1  9.36M      DISK        00:00:02     14-JUN-14
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T162841
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\0APAR3VR_1_1
  SPFILE Included: Modification time: 14-JUN-14
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 1391703      Ckp time: 14-JUN-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 2  144.00K    DISK        00:00:54     14-JUN-14
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T163135
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\0BPAR438_1_1
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    2  Incr 1391751    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_9S5MLC2X_.DBF
  2    2  Incr 1391751    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_9S5MLC4W_.DBF
  3    2  Incr 1391751    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_9S5MLC6T_.DBF
  4    2  Incr 1391751    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_USERS_9S5MLC9R_.DBF
  5    2  Incr 1391751    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_EXAMPLE_9S5MPS1Y_.DBF
  6    2  Incr 1391751    14-JUN-14 K:\ORADATA\ORCL\DATAFILE\O1_MF_TS_TEST_9S5NNK0Z_.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Incr 2  9.36M      DISK        00:00:04     14-JUN-14
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20140614T163135
        Piece Name: D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\0CPAR44V_1_1
  SPFILE Included: Modification time: 14-JUN-14
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 1391769      Ckp time: 14-JUN-14


0 0