1.14. Answers to Review Questions

  1. C. The CONTROL_FILE_RECORD_KEEP_TIME parameter is the parameter that determines the size of the RMAN repository or target database's control file when not using the recovery catalog.

  2. A, C. The RECOVERY_CATALOG_OWNER and RESOURCE privileges are required to create the recovery catalog. The DBA privilege includes RESOURCE and CONNECT and will work, but this role has many additional privileges that are unneeded. SELECT ANY DICTIONARY TABLE is not required.

  3. A, C. The TYPE DISK parameter allocates a channel to disk. The TYPE SBT_TAPE parameter allocates a channel to tape. These are the two correct device types.

  4. B. The correct configure command is CONFIGURE CHANNEL DEVICE TYPE DISK. When using the CONFIGURE command, the information is stored as a default so that it doesn't need to be specified in backup, restores, or deletes.

  5. D. The Media Management Layer (MML) is the API that interfaces RMAN with different vendor tape devices.

  6. A. Password file backups are not supported with the RMAN utility.

  7. A, B, D. The database connection types supported with RMAN are target database, recovery catalog, and auxiliary database.

  8. B. The channel options and commands are used to control the operating system resources that RMAN uses. Specifically, the RATE and DURATION options protect a RMAN backup from consuming all operating system resources.

  9. A. The FORMAT command allows for unique identification of a backup or image copy.

  10. C. The SHOW ALL command displays all configuration settings, including automated channel setup settings. These are also known as the persistent settings.

  11. A. The COMPRESSED BACKUPSET command allows you to compress backup sets to a smaller size, allowing for storage of larger databases.

  12. C. Block change tracking allows RMAN to back up only changed blocks from the last backup. The blocks are identified in a journaling system to expedite the process.

  13. D. All of the answers describe capabilities of the BACKUP command that are not available when using the image copy method of backing up.

  14. A, C, D. The command-line interface is always required to use RMAN. EM, the recovery catalog, and MML are not mandatory to use RMAN.

  15. C. The circular reuse records contain information that will be written over when necessary.

  16. B, D. Multiple channels are needed to allow backup or recovery functions to be processed over each. The PARALLISM parameter can be configured to a number greater than 1, and this allocates multiple channels for parallelization.

  17. C, D. EM uses the operating system account with significant privileges to run RMAN to perform operations. The Oracle account is needed on Unix and the administrator account or its equivalent in the Windows environment.

  18. D. RMAN persistent settings can control or define devices, backups, and channels. Persistent settings control all values available in the SHOW ALL command.

  19. B, C. Persistent settings are stored in the control file of the target database when using the control file as the repository. Persistent settings are also stored in the recovery catalog when using the recovery catalog as the repository.

  20. C. Compression backup by backing up only changed blocks was the primary method of compression prior to 10g. Now with 10g, backups can be compressed regardless of the used or unused blocks.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset