684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME ‘2007-02-28:10:15:00’;
Identify the files that must be restored to recover the missing tables successfully.
A.Restore the backup of all the data files.
B.Restore the backup of all the data files and the control file.
C.Restore the backup of only the data files that contain the dropped tables.
D.Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
Answer:A
因为执行数据库不完全恢复，必须先restore database，RESTORE回所有数据文件。
如果是执行表空间的时间点恢复，则应该选D，RESTORE回相关表空间的数据文件。
You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME ‘2007-02-28:10:15:00’;
Identify the files that must be restored to recover the missing tables successfully.
A.Restore the backup of all the data files.
B.Restore the backup of all the data files and the control file.
C.Restore the backup of only the data files that contain the dropped tables.
D.Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
Answer:A
因为执行数据库不完全恢复，必须先restore database，RESTORE回所有数据文件。
如果是执行表空间的时间点恢复，则应该选D，RESTORE回相关表空间的数据文件。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2122298/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q532
下一篇：
1Z0-053 V13.02 Q685
请登录后发表评论
登录
全部评论
