|
Explanation: To minimize both downtime and data loss you need to restore the SYSTEM table space data file from Sunday’s backup, and all the archive log files from Monday and Tuesday. After that recover database. If there is no loss of online redo logs you can recover database without any data loss. Incorrect Answer: 1: You need also some archived log files, because the database consists only 10 redo log groups, but from Sunday it happened 17 log switches, so some redo logs have been overwritten already. 3: You cannot restart database with corrupted SYSTEM table space. You can just put corrupted non-SYSTEM table space offline to restart the database to allow users back onto the database and after that recover this table space. 4: To minimize the downtime you don’t need to restore ALL the data files from Sunday’s backup: only SYSTEM table space data files should be restored and recovered using archiving redo logs. Reference: OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 303 Chapter 12: User-Managed Complete Recovery
|