Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 96

Review Questions
1. Your NOARCHIVELOG database has experienced a loss of data file users_01.dbf ,
which is associated with a tablespace called USERS . The database is still running. Which
of the following is the most correct answer?
A. You can take the data file offline, restore the data file from a backup, and then
recover the data file using the archived redo logs. You would then bring the data
file back online.
B. You will have to shut down the database and restore the database, online redo
logs, and control files that were contained in the last backup. You can then restart
the database. There will be data loss.
C. You will have to shut down the database and restore the database, online redo
logs, and control files that were contained in the last backup. You can then restart
the database. There will be no data loss.
D. This failure is not recoverable. You will need to force open the database and then
force a recovery.
E. None of the above is correct.
2. As soon as you discover that you have lost an online redo log, if the database is still
functioning, what should be your first action?
A. Shut down the database.
B. Clear the online redo log.
C. Back up the database.
D. Checkpoint the database.
E. Call Oracle support.
F. Panic.
3. You have lost all your SYSTEM tablespace data files ( system_01.dbf and
system_02.dbf ) and the database has crashed. The database is in ARCHIVELOG
mode and you have a current backup. What would be the appropriate order of opera-
tions to correct the situation?
1. Mount the database with the STARTUP MOUNT command.
2. Take the SYSTEM data file offline with the ALTER DATABASE command.
3. Restore the SYSTEM _ 01.dbf data file from backup media with the required archived
redo logs.
4. Restore all SYSTEM tablespace-related data files from backup media.
5. Issue the RECOVER TABLESPACE SYSTEM command.
6. Issue the RECOVER DATAFILE SYSTEM_01.DBF command.