Oracle OCP 9i to 11g Using the Data Recovery Advisor

Card Set Information

Author:
Tralala
ID:
193403
Filename:
Oracle OCP 9i to 11g Using the Data Recovery Advisor
Updated:
2014-05-29 10:26:48
Tags:
Oracle OCP 9i 11g Using Data Recovery Advisor
Folders:

Description:
Oracle OCP 9i to 11g 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. Which Oracle feature diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request?
    Data Recovery Advisor
  2. What does the RMAN command LIST FAILURE do?
    List OPEN failures with a priority of CRITICAL or HIGH
  3. What is a CRITICAL priority failure?
    • Requires immediate attention.
    • Whole database is unavailable.
  4. What is a HIGH priority failure?
    Database is partially unavailable.
  5. What is a LOW priority failure?
    Failure can be ignored until more important things are fixed.
  6. What does the RMAN command ADVISE FAILURE do
    An approach for fixing the issue
  7. What are the reported sections ADVISE FAILURE?
    • Mandatory Manual Actions
    • Optional Manual Actions
    • Automated Repair Actions
  8. What happens in an Automated Repair?
    • The repair is performed
    • The repair is verified
    • The failure notice is closed
  9. What is the advised workflow when using Data Recovery Advisor?
    • LIST FAILURE
    • ADVISE FAILURE
    • REPAIR FAILURE
  10. Which RMAN command in Data Recovery Advisor, tells of what has gone wrong?
    LIST FAILURE
  11. What are the DB_BLOCK_CHECKING options?
    OFF | LOW | MEDIUM | FULL
  12. What are the DB_BLOCK_CHECKSUM options?
    OFF | LOW | MEDIUM | FULL
  13. What are the DB_LOST_WRITE_PROTECT options?
    NONE | TYPICAL | FULL
  14. What are the DB_ULTRA_SAFE options?
    • OFF
    • DATA_ONLY : DB_BLOCK_CHECKING MEDIUM DB_BLOCK_CHECKSUM TYPICAL DB_LOST_WRITE_PROTECT FULL
    • DATA_AND_INDEXES : DB_BLOCK_CHECKING MEDIUM DB_BLOCK_CHECKSUM TYPICAL DB_LOST_WRITE_PROTECT FULL
  15. What does VALIDATE DATABASE command do?
    • Validates all datafiles and controlfiles
    • Checks for corrupt blocks
    • Checks for missing files
    • Checks SPFILE is being used
  16. Where are findings of VALIDATE DATABASE stored?
    V$DATABASE_BLOCK_CORRUPTION
  17. What type of corruption does VALIDATE DATABASE check for?
    Physical
  18. How can VALIDATE DATABASE check for logical corruption?
    Using CHECK LOGICAL
  19. What types of file does VALIDATE DATABASE validate?
    • datafiles
    • control files
    • spfile
  20. What kind of corruption can VALIDATE DATABASE find?
    Intrablock Corruptions
  21. Which dynamic dictionary view can be queried to list information for all open and closed failures identified with the ADVISE FAILURE?
    V$IR_FAILURE
  22. Which dynamic dictionary view can be queried to list information on repairs identified with the ADVISE FAILURE?
    V$IR_REPAIR
  23. ADVISE FAILURE will show what type of failure?
    • HIGH
    • CRITICAL
  24. What happens to a failure when REPAIR FAILURE has successfully completed?
    It's closed
  25. What command closes a failure?
    CHANGE FAILURE <FAILURE ID> CLOSE;
  26. How are failures listed in LIST FAILURE?
    Failures with the same priority are listed chronologically CRITICAL -> HIGH
  27. Where can Data Recovery Advisor NOT be run.
    Against a RAC database
  28. What are the options for DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM?
    • OFF
    • LOW
    • MEDIUM
    • FULL
  29. What are the options for DB_LOST_WRITE_PROTECT?
    • NONE
    • TYPICAL
    • FULL

What would you like to do?

Home > Flashcards > Print Preview