单项选择题
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()
A. The target database must be in the MOUNT mode to ensure restoration of the datafiles.
B. You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
C. The control file must be recreated.
D. The database must be opened with the RESETLOGS option.
相关考题
-
单项选择题
YouaremaintainingyourdatabaseinARCHIVELOGmode.Animportanttable,SCOTT.EMPLOYEE,isdroppedandpurgedfromtheRecycleBinonMondayat2:00P.M.YoudonotuseRMANtoperformbackups.Youperformedthelastfulluser-managedbackupat9:00P.M.onSunday.Howwillyourecoverthedroppedtable,SCOTT.EMPLOYEE?()
A. by using the Flashback Table feature
B. by using the Flashback Database feature
C. by performing incomplete recovery using RMAN utility
D. by performing incomplete recovery using user-managed recovery -
单项选择题
You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement: SQL>ALTER DATABASE OPEN RESETLOGS; What will be the resultant log sequence numbers?()
A. 0 and 1
B. 1 and 2
C. 1005 and 1006
D. 1006 and 1007 -
单项选择题
Inwhichscenariowillyouperformauser-managedincompleterecovery?()
A. when a table is dropped and stored in the Recycle Bin
B.when a table is dropped and purged from the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when you are required to view all the versions of a row of an existing table between a specific time period
