RelationalDBDesign
SiteMap
Recovery Methods
Oracle Recovery
Database Backup
Backup Options
«Prev
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
Infrequent Recovery Situations and Redo Log Maintenance - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
After a media failure is corrected, you find out the tablespace EMPLOYEE_HISTORY is corrupted. This tablespace was created two days ago and there is no backup. However, all the archived logs are available for the past 5 business days. Which of the following complete recovery methods do you use to recover the tablespace?
Please select the best answer.
A.
Recover a closed database
B.
Recover a datafile with no backup
C.
Recover an open database, initially open
D.
Recover an open database, initially closed
2.
In the process of recovering a datafile with no backup, which of the following are valid steps?
Please select all the correct answers.
A.
Take the damaged datafile offline
B.
Restore the damaged datafile to a different location
C.
Recreate the damaged datafile to a different location
D.
Recover the affected datafile by applying all archived and online redo logs
3.
When you issue the ALTER DATABASE CLEAR UNARCHIVED LOG FILE GROUP <group_number> command, what happens?
Please select all the correct answers.
A.
The damaged online redo log file is dropped and recreated.
B.
The offline datafiles become useless if the cleared log file is needed for recovery.
C.
Incomplete recovery of the database becomes impossible.
D.
Complete recovery of the database becomes impossible.
4.
Before you finish your routine open database backup of a tablespace, a power outage occurs and the database is brought down. You try to open the database, but fail. Now your database is in the mount mode. What could you do?
Please select all the correct answers.
A.
Perform a complete database recovery
B.
Take the tablespace in the backup mode offline
C.
Issue the command
ALTER TABLESPACE ...END BACKUP
D.
Issue the command
ALTER DATABASE DATAFILE ... END BACKUP
5.
Which of the following data dictionary views are only available after you issue the ALTER DATABASE RECOVER command?
Please select all the correct answers.
A.
V$RECOVERY_LOG
B.
V$RECOVERY_FILE_STATUS
C.
V$RECOVER_FILE
D.
V$RECOVERY_STATUS