单项选择题
Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）
A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
D. restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
相关考题
-
单项选择题
Thelossofthecontrolfileforcedyoutore-createthecontrolfile.Afterre-creatingitandopeningthedatabase，youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn，wherennnnnisafive-digitnumberstartingwith0.Whatcouldbethepossiblereason？（）
A. These are the data files that are corrupted.
B. There is no SYSAUX tablespace in your database
C. There is a read-only tablespace in your database.
D. These are the data files that cannot be recovered. -
单项选择题
YoulostthePRODSTDtablespace，whichwasread-only.Thetablespacewasread-onlywhenthelastbackupwastaken.Howwouldyourecoverthetablespace？（）
A. restore the tablespace from the backup， and then perform an incomplete recovery
B. restore the tablespace from the backup， and then apply all the redo information
C. restore all the data files in the database， and then perform an incomplete recovery
D. restore the tablespace from the backup -
多项选择题
WhichtwostatementsregardingcompressedbackupsinRecoveryManager（RMAN）aretrue？（）
A. Backup compression is disabled by default.
B. Backup compression can be used with both backup sets and image copies.
C. Backup compression cannot be enabled using the CONFIGURE command.
D. Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
E. Backup compression applies to only backup sets.
F. Backup compression applies to only image copies.
