99. You lost a data file that belongs to an index tablespace in your
database, which operates in ARCHIVELOG mode. Loss of the data file re
sulted in increased response time on your queries.
Which two options would you use to solve this problem? (Choose two)
A. Restore the lost data file from the backup, and then flash back th
e database.
B. Restore the data file pertaining to index tablespace, and then rec
over the tablespace.
C. Restore all the data files, and then perform. an incomplete recover
y to get the tablespace back.
D. Restore all the data files, and then perform. an incomplete recover
y using the backup control file.
E. Drop and re-create the index tablespace, and then re-create all of
the indexes in that tablespace.
Answer: B, E
在你索引表空间中的数据文件丢失，会造成你的数据库提问的响应时间，这
时你可以drop 掉这个索引表空间，然后重建表空间，重建索引。或者restore 该
数据文件，然后再recover 该表空间(需试验,难道可以针对单个文件恢复?)。
(warehouse)不完全恢复只能针对整个数据库，不能针对某个表空间或某个数
据文件
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718002/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
