单项选择题
In which scenario will you perform a cancel-based recovery?()
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 -
单项选择题
Inwhichscenariowillyouperformanincompleterecovery?()
A. when a table is dropped and stored in the Recycle Bin
B. when all the control files are deleted
C. when a member of a multiplexed redo log group is dropped
D. when you are required to recover a table to its previous state
