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