Oracle
1Z0-043 · Question #71
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?
The correct answer is D. restore the tablespace from the backup and then recover the tablespace; all the redo information. See the full explanation below for the reasoning.
Question
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?
Options
- Arestore the tablespace from the backup; there is no need to apply the redo information
- Brestore the full database to recover the data up to the point when you performed the backup
- Crestore the tablespace from the backup and then perform a recovery using the backup control file
- Drestore the tablespace from the backup and then recover the tablespace; all the redo information
How the community answered
(26 responses)- A12% (3)
- B15% (4)
- C4% (1)
- D69% (18)
Community Discussion
No community discussion yet for this question.