表空间的丢失与恢复

151. 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?
A.restore the tablespace from the backup there is no need to apply the redo information.
B.restore the full database to recover the data up to the point when you performed the backup.
C.restore the tablespace from the backup, and then perform a recovery using the backup control file.
D.restore the tablespace from the backup, and then recover the tablespace all the redo information from the point when the tablespace was made read/write is applied.

丢失表空间PRODSTD时,表空间是read/write状态.最后一次备份表空间PRODSTD时的状态是readonly.在此种情况下应当如何恢复?

restore tablespace -> recover tablespace -> apply the redo logfile from the point when the tablespace was make read/write.

posted @ 2013-08-09 13:17  ArcerZhang  阅读(204)  评论(0编辑  收藏  举报