Oracle 1Z0 053 Q684(Incomplete Recovery)

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


既然有recover database，就應該有restore database。恢復某幾個資料檔案或者表空間無法保證資料庫的一致性

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074535/，如需轉載，請註明出處，否則將追究法律責任。