OCP 16 Using the Data Recovery Advisor

Card Set Information

Author:
Tralala
ID:
213636
Filename:
OCP 16 Using the Data Recovery Advisor
Updated:
2013-04-15 09:32:12
Tags:
OCP 16 Using Data Recovery Advisor
Folders:

Description:
OCP 16 Using the Data Recovery Advisor
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. What is the maximum number of RMAN repair processes that can run concurrently?
    One
  2. For which types of failures does the Data Recovery Advisor make manual repair recommendations?
    Those requiring human intervention and those that can be repaired more quickly manually
  3. Which new RMAN command can be used to check for intrablock corruptions at the backup set, tablespace, datafile, or block level?
    The VALIDATE command
  4. When you use set the DB_ULTRA_SAFE parameter to DATA_AND_INDEX, what is the result?
    DB_BLOCK_CHECKING is set to FULL or TRUE, DB_LOST_WRITE_PROTECT is set to TYPICAL, and DB_BLOCK_CHECKSUM is set to FULL.
  5. What is the result of issuing the LIST FAILURE; RMAN command?
    Information for all open failures in the ADR with a high or critical status is displayed.
  6. If you execute an RMAN VALIDATE command, what is the result if intrablock corruptions are detected?
    They are recorded as findings in the ADR.
  7. Which new parameter can you specify to change the default values of the DB_BLOCK_CHECKING, DB_LOST_WRITE, and DB_BLOCK_CHECKSUM parameters?
    The DB_ULTRA_SAFE parameter
  8. What is the result if you issue an ADVISE FAILURE command and new failures have been recorded in the ADR since the last LIST FAILURE command was executed?
    A warning message is displayed.
  9. When you use set the DB_ULTRA_SAFE parameter to DATA_ONLY, what is the result?
    DB_BLOCK_CHECKING is set to MEDIUM, DB_LOST_WRITE_PROTECT is set to TYPICAL, and DB_BLOCK_CHECKSUM is set to FULL.
  10. What is the result if you issue the REPAIR FAILURE RMAN command to repair a data failure and have not previously executed the ADVISE FAILURE command in the same RMAN session?
    The command fails.
  11. Which action should you take to change the priority of a failure recorded in the ADR from HIGH to LOW?
    The CHANGE FAILURE command
  12. Which advisor automatically detects data failures and makes recommendations for how to repair the failures?
    The Data Recovery Advisor
  13. Which RMAN command should you execute to explicitly close an open failure?
    The CHANGE FAILURE command
  14. What is the result if you specify a DB_LOST_WRITE_PROTECT parameter of TYPICAL?
    Performs checks for lost writes
  15. What is the result of issuing the ADVISE FAILURE; RMAN command?
    Manual and automated repair options are displayed for all open failures with a high or critical status, and an RMAN script is created for automated repair options.
  16. Does the Data Recovery Advisor detect and analyze offline data failures, online data failures, or both offline and online data failures?
    Both offline and online data failures
  17. To successfully issue the REPAIR FAILURE RMAN command to repair a data failure, which RMAN command must you have previously executed in the same RMAN session?
    The ADVISE FAILURE command

What would you like to do?

Home > Flashcards > Print Preview