The flashcards below were created by user
Tralala
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?
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?
-
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?
-
What are the options for DB_LOST_WRITE_PROTECT?
|
|