单项选择题
Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery:
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
7> };
With reference to this scenario, which statement is true?()
A. RMAN recovers up to log sequence 230, but not including 230.
B. RMAN returns an error because the log sequence number mentioned in the command should be 229.
C. RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D. RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
相关考题
-
单项选择题
YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourOracle10gdatabase:RMAN>REPORTNEEDBACKUPdays3;Whatwouldbetheoutputofthiscommand?()
A. a list of files that require a backup within three days
B. a list of files that have not been backed up for three days
C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. a list of files for which a backup has already been performed and may need a backup after three days -
单项选择题
Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicationtablespacetobe60%and70%respectively.Fromthetablespacespaceusagemetrics,youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?()
A. The EVENT parameter was not set
B. The SQL_TRACE parameter is set to FALSE
C. The Enterprise Manager Grid Control is not used
D. The STATISTICS_LEVEL parameter is set to BASIC
E. The TIMED_STATISTICS parameter is set to FALSE -
多项选择题
YouworkasadatabaseadministratoratCertkiller.com.Inyourproductiondatabase,youobservethatusers’transactionsareconsumingalotofresourceandyouplantoimposeresourcerestrictionsbyusingResourceManager.ForwhichthreeresourcescanyouenableusagerestrictionsbyusingResourceManager?()
A. CPU usage
B. degree of parallelism
C. number of open cursors
D. number of sorts performed
E. idle time for blocking sessions
F. number of disk I/O operations performed
G. number of memory I/O operations performed
