|
Explanation: There is only one complex recovery situation for read-only table spaces. This is when your readonly table space experiences media failure, and the backup you have was taken when the table space was in read-write state. In order to manage this recovery, you must first recover the table space from backups taken when it was a writable table space and apply redo logs to update the objects in that table space up to point when the table space was made read-only. Then, you can change the table space state to read-only. A DBA needs to do complete media recovery if restores a read-only table space from a backup taken BEFORE the table space was made read-only. Incorrect Answers: 1: A DBA does not need to recreate the control file in this case. 3: A DBA does not need to make the table space locally managed in this case. 4: A DBA can use the table space BEFORE it became read-only. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 721 Chapter 15: Advanced Topics in Data Recovery
|