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

586. Consider the following command:

Backup database plus archivelog delete input;

How many backup sets wocould 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

Answer:

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/blank _. 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/blank _. 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/blank _. 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.68 m 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

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.00 k disk 00:00:00

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.36 m disk 00:00:02

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 encoded ded: Modification time: 19-DEC-13

SPFILE db_unique_name: TESTDB

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