Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 121:

  What type of backup is stored in a proprietary RMAN format?

  A. Backup set

  B. Image copy

  C. Backup section

  D. Backup group

  Correct Answer: A

  A backup set is an RMAN-specific proprietary format, whereas an image copy is a bit-for-bit copy of a file.

  By default, RMAN creates backup sets.

  Refer to here

• Question 122:

  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

  Correct 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;

• Question 123:

  View the Exhibit and examine the RMAN commands.

  

  Which statement describes the effect of a backup retention policy on the backup of a backup set?

  A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.

  B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.

  C. The copies of the backup will be reported as obsolete under a recovery window-based backup retention policy.

  D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup set exceeds the redundancy-based backup retention policy.

  Correct Answer: A

• Question 124:

  Which two statements are true about an image copy backup? (Choose two.)

  A. It may only be taken to disk.

  B. It will contain only the used blocks.

  C. It will contain all used and unused blocks.

  D. It can be performed on disk as well as on tape.

  Correct Answer: AC

• Question 125:

  Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all that apply.)

  A. To check that the obsolete backups are deleted from the repository records and from the disk.

  B. To update the RMAN repository if you delete archived redo logs with operating system commands.

  C. To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.

  D. To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which the backup was not taken using RMAN.

  Correct Answer: BC

  Crosscheck are useful because they can do the following: (Link) Update outdated information about backups that disappeared from disk or tape or became corrupted

  Update the repository if you delete archived redo logs or other files with operating system commands Use the CROSSCHECK command to synchronize the physical reality of backups and copies with their logical records in the RMAN

  repository.

  The CROSSCHECK command checks only objects marked AVAILABLE or EXPIRED in the repository by examining the files on disk for DISK channels or by querying the media manager for sbt channels.

  Meaning of Crosscheck Status:

  EXPIRED

  Object is not found either in file system (for DISK) or in the media manager (for sbt). A backup set is EXPIRED if any backup piece in the set is EXPIRED. The CROSSCHECK command does not delete the repository records of the files that it

  does not find, but updates their repository records to EXPIRED. You can run DELETE EXPIRED to remove the repository records for expired files and any existing physical files whose status is EXPIRED.

  If backups are EXPIRED, then you can re-execute the crosscheck later and determine whether expired backups are available. This precaution is especially useful when you use RMAN with a media manager. For example, if some backup

  pieces or copies were erroneously marked as EXPIRED because the PARMS channel settings were incorrect, then after ensuring that the files really do exist in the media manager, run the CROSSCHECK BACKUP command again to restore

  those files to AVAILABLE status.

  AVAILABLE

  Object is available for use by RMAN. For a backup set to be AVAILABLE, all backup pieces in the set must have the status AVAILABLE.

• Question 126:

  What does the output on this report indicate?

  

  A. The my_data_01.dbf datafile is corrupted and needs to be restored.

  B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.

  C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.

  D. The my_data_01.dbf datafile no longer meets the retention criteria for backups.

  E. Datafile 5 is missing.

  Correct Answer: B

• Question 127:

  What is the result of this command? RMAN> Report need backup days 3;

  A. Lists all datafiles created in the last three days that are not backed up.

  B. Lists all datafiles not recoverable based on the current retention criteria.

  C. Lists all datafiles not backed up in the last three days. The datafile is not recoverable.

  D. Lists all datafiles that need to be backed up due to unrecoverable operations.

  E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.

  Correct Answer: E

• Question 128:

  Why would you execute the report obsolete command?

  A. To list all backups that were no longer available for restore operations

  B. To list all backups that had aged beyond the RMAN retention criteria

  C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media

  D. To list all datafiles that are no longer part of the database and thus do not need to be backed up

  E. To list all archived redo logs that are no longer needed for any database recovery

  Correct Answer: B

  You can report backup sets, backup pieces, and data file copies that are obsolete that is, not needed to meet a specified retention policy by specifying the OBSOLETE keyword.

• Question 129:

  What information does the report schema command not provide? (Choose all that apply.)

  A. Size of the datafiles

  B. Size of the tempfiles

  C. Date of last backup for datafiles and tempfiles

  D. Filenames for each datafile

  E. Checkpoint SCN associated with the last RMAN backup

  Correct Answer: CE

• Question 130:

  If a backup set is expired, what can you do to correct the problem?

  A. Change the retention criteria.

  B. Make the lost backup set pieces available to RMAN again.

  C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.

  D. Nothing. The backup set piece is lost forever.

  E. Call Oracle support, their assistance is required.

  Correct Answer: B