ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-099

043-099

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-07 21:40:51 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718002/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-098
下一篇: 043-100
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205462