单项选择题
A. user managed complete recovery
B. user managed incomplete recovery
C. RMAN-based complete recovery
D. RMAN-based incomplete recovery
单项选择题 You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code?() RMAN>RUN { SET UNTIL SEQUENCE THREAD ; RESTORE DATABASE; RECOVER DATABASE; }
单项选择题 Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement: SQL> DROP TABLE SCOTT.EMP PURGE; After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()
单项选择题 YouaremaintainingyourdatabaseinOracle10g.OnTuesdayat8:00A.M.,whilestartingthedatabase,youdiscoverthatallthecontrolfilesaremissing.ThebackupofthefulldatabasewasperformedonSundayat6:00P.M.Whichtypeofrecoverywillyouperform?()