单项选择题
In which situation are you NOT required to perform an incomplete recovery？（）
A. when all the control files are lost
B. when all the members of a redo log group are lost
C. when a table is dropped and purged from the Recycle Bin
D. when a temporary file of the default temporary tablespace is lost
相关考题
-
单项选择题
Inwhichscenariowillyouperformacancel-basedrecovery？（）
A. when a tablespace is dropped and you have only RMAN-based backup of the database
B. when a table is dropped and stored in the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when a tablespace is dropped and you have only a user-managed full backup of the database -
单项选择题
YouaremaintainingthePRODdatabaseforNetFxCorporation.Youhaveconfiguredcontrolfileautobackupinyourdatabase.At6：00P.M.onMonday，youissuethefollowingcommand：RMAN>BACKUPDATABASE；At8：00A.M.onTuesday，youareunabletostartthedatabasebecauseallthecontrolfilesaremissing.YoudecidetorestorethecontrolfilesfromthebackupbyusingtheRMAN>RESTORECONTROLFILEFROMAUTOBACKUP；command.WhichoperationshouldyouperformbeforeusingtheRMAN>RESTORECONTROLFILEFROMAUTOBACKUP；command？（）
A. Start the database in the MOUNT stage.
B. Back up the control file to trace.
C. Set the DBID
D. Issue the RECOVER DATABASE command. -
单项选择题
In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；
A. when all the control files are missing and only a binary backup of the current control file exists
B. when a multiplexed copy of the current control file is missing
C.when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D. when the SPFILE is missing
