ITPub博客

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

043-021

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-04 14:37:35 0 删除 编辑
21. Your database operates in ARCHIVELOG mode. User-managed consisten
t backups are performed every Sunday night.
On Tuesday, client A drops a table at 8:00 a.m. as follows:
SQL> DROP TABLE cust_ord PURGE;
Table dropped.
Client B executes a query at 9:00 a.m. on the same table as follows:
SQL> SELECT * FROM cust_ord;
SELECT * FROM cust_ord
ERROR at line 1:
ORA-00942: table or view does not exist
Client B needs the dropped table and reports the problem to you.
With reference to this scenario, which action should you take?
A. retrieve the table by using the flashback feature
B. restore all the data files from last Sunday's backup and then perf
orm a time-based recovery
C. restore all the data files from last Sunday's backup and then perf
orm a log sequence recovery
D. restore all the data files from last Sunday's backup and then perf
orm a cancel-based recovery
E. restore from last Sunday's backup only data files that belong to t
he tablespace in which the table was stored and then perform. a comple
te recovery
Answer: B
知道确切的时间了,应该使用基于时间的恢复。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717640/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214089