Oracle OCP 9i to 11g Using the Data Recovery Advisor
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
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
What does the RMAN command LIST FAILURE do?
List OPEN failures with a priority of CRITICAL or HIGH
What is a CRITICAL priority failure?
- Requires immediate attention.
- Whole database is unavailable.
What is a HIGH priority failure?
Database is partially unavailable.
What is a LOW priority failure?
Failure can be ignored until more important things are fixed.
What does the RMAN command ADVISE FAILURE do
An approach for fixing the issue
What are the reported sections ADVISE FAILURE?
- Mandatory Manual Actions
- Optional Manual Actions
- Automated Repair Actions
What happens in an Automated Repair?
- The repair is performed
- The repair is verified
- The failure notice is closed
What is the advised workflow when using Data Recovery Advisor?
- LIST FAILURE
- ADVISE FAILURE
- REPAIR FAILURE
Which RMAN command in Data Recovery Advisor, tells of what has gone wrong?
What are the DB_BLOCK_CHECKING options?
OFF | LOW | MEDIUM | FULL
What are the DB_BLOCK_CHECKSUM options?
OFF | LOW | MEDIUM | FULL
What are the DB_LOST_WRITE_PROTECT options?
NONE | TYPICAL | FULL
What are the DB_ULTRA_SAFE options?
- 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
What does VALIDATE DATABASE command do?
- Validates all datafiles and controlfiles
- Checks for corrupt blocks
- Checks for missing files
- Checks SPFILE is being used
Where are findings of VALIDATE DATABASE stored?
What type of corruption does VALIDATE DATABASE check for?
How can VALIDATE DATABASE check for logical corruption?
Using CHECK LOGICAL
What types of file does VALIDATE DATABASE validate?
- control files
What kind of corruption can VALIDATE DATABASE find?
Which dynamic dictionary view can be queried to list information for all open and closed failures identified with the ADVISE FAILURE?
Which dynamic dictionary view can be queried to list information on repairs identified with the ADVISE FAILURE?
ADVISE FAILURE will show what type of failure?
What happens to a failure when REPAIR FAILURE has successfully completed?
What command closes a failure?
CHANGE FAILURE <FAILURE ID> CLOSE;
How are failures listed in LIST FAILURE?
Failures with the same priority are listed chronologically CRITICAL -> HIGH
Where can Data Recovery Advisor NOT be run.
Against a RAC database
What are the options for DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM?
What are the options for DB_LOST_WRITE_PROTECT?
What would you like to do?
Home > Flashcards > Print Preview