RelationalDBDesign
SiteMap
Recovery Methods
Oracle Recovery
Database Backup
Backup Options
«Prev
Next»
Database Backup
Physical Backups Archiving
Database Backup Concepts
OS Backup Options
Closed Database Backups
Performing Closed DB Backup
Open Database Backups
Open DB Backup Options
Performing Open DB Backup
Backingup Control File
Monitoring Open DB Backup
Logging nologging Modes
Read Only Backups
Physical Backups Conclusion
Noarchivelog Mode Recovery
Identify Required Structures
Restoring Noarchivelog
DB Recovery Implications
Recovering NoArchivelog DB
Restoring Files
Noarchivelog Recovery
Recovery with Archiving
Identifying Instance failure Implications
Listing Different Recovery Methods
Complete Recovery Operation
Closed Database Recovery
Recovering Initially Open
Recovering Initially Closed
Archivelog DB Recovery Conclusion
Archiving Incomplete Recovery
Identifying Incomplete Recovery
Different Incomplete DB Recovery
Incomplete DB Recovery Steps
Monitoring Oracle Recovery Progress
Cancel Based Recovery
Backup Controlfile to Recover
Recovering without current RedoLog
Performing Recovery through Resetlogs
Point-in-time Recovery Concepts
Performing Incomplete Recovery
Infrequent Recovery Situations
Clearing Corrupt Online Redo log Files
Recovering Database with Inactive redoLogs
Clearing Corrupt Online Redo log Files
Recreate Redo Log Files
Monitoring Recovery Status
DB Downtime Prevention
Parallel Recovery Operations
ReadOnly Tablespace Recovery
Minimizing Database Downtime[for recovery] - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Parallel recovery was invented for which of the following reasons?
Please select the best answer.
A.
Applying changes to more than one disk simultaneously
B.
Applying changes to more than one datafile
C.
Applying changes from more than one redo log
D.
Speeding up the recovery process
2.
If you start a database with a missing database file, which of the following are true?
Please select all the correct answers.
A.
The missing database file belongs to the system or rollback segment tablespaces.
B.
The missing database file has to be taken offline before the database can be opened.
C.
The missing database file belongs to the application tablespace.
D.
The missing database file is the control file.
3.
Which of the following actions can you take when performing automatic parallel recovery?
Please select all the correct answers.
A.
Start several recovery sessions and issue the
RECOVER
command in each of them
B.
Start one recovery session and issue the
RECOVER
command with the PARALLEL clause
C.
Set the
PARALLEL_MAX_SERVERS
parameter and issue the RECOVER command
D.
Set the
RECOVERY_PARALLELISM
parameter and issue the RECOVER command