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