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?
LIST FAILURE
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?
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
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?
V$DATABASE_BLOCK_CORRUPTION
What type of corruption does VALIDATE DATABASE check for?
Physical
How can VALIDATE DATABASE check for logical corruption?
Using CHECK LOGICAL
What types of file does VALIDATE DATABASE validate?
datafiles
control files
spfile
What kind of corruption can VALIDATE DATABASE find?
Intrablock Corruptions
Which dynamic dictionary view can be queried to list information for all open and closed failures identified with the ADVISE FAILURE?
V$IR_FAILURE
Which dynamic dictionary view can be queried to list information on repairs identified with the ADVISE FAILURE?
V$IR_REPAIR
ADVISE FAILURE will show what type of failure?
HIGH
CRITICAL
What happens to a failure when REPAIR FAILURE has successfully completed?
It's closed
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?
OFF
LOW
MEDIUM
FULL
What are the options for DB_LOST_WRITE_PROTECT?
NONE
TYPICAL
FULL
Author
Tralala
ID
193403
Card Set
Oracle OCP 9i to 11g Using the Data Recovery Advisor
Description
Oracle OCP 9i to 11g Using the Data Recovery Advisor