单选题Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）Arestore datafiles until time '09/28/2008:21:03:11'Brestore database files until time '09/28/2008:18:00:00'Crestore database until time '09/28/2008:18:00:00'Drecover database until time '09/28/2008:18:00:00'Erecover database until timestamp '09/28/2008:18:00:00'
单选题
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）
A
restore datafiles until time '09/28/2008:21:03:11'
B
restore database files until time '09/28/2008:18:00:00'
C
restore database until time '09/28/2008:18:00:00'
D
recover database until time '09/28/2008:18:00:00'
E
recover database until timestamp '09/28/2008:18:00:00'
参考解析
解析：
暂无解析
相关考题：
WhatwillbetheendresultofthissetofRMANcommands?()shutdownabortstartupmountrestoredatafile4untiltime,,09／30／2008:15:00:00;recoverdatafile4untiltime,,09／29／2008:15:00:00;alterdatabaseopenresetlogs; A.Datafile4willberecovereduntil9/30/2008at15：00andthedatabasewillopen.B.Therestorecommandwillfail.C.Therecovercommandwillfail.D.Thealterdatabaseopenresetlogscommandwillfail.E.Allthesecommandswillfailbecausetheymustbeintheconfinesofarunblock.
Youneedtorestoreyourdatabasebackto9/30/2008at18：00.Inwhatorderwouldyourunthefollowingcommandstocompetethistask？（）a.restorecontrolfileuntiltime`09/30/2008：18：00：00’b.restoredatabaseuntiltime`09/30/2008：18：00：00’c.restorespfileuntiltime`09/30/2008：18：00：00’d.recoverdatabaseuntiltime`09/30/2008：18：00：00’e.alterdatabaseopenresetlogsf.alterdatabaseopenA.b，d，eB.b，d，fC.c，a，b，d，eD.c，a，b，d，fE.a，b，d，e
Whichcommandwillrestorealldatafilestothedate9／30／2008at18:00hours?() A.restoredatafilesuntiltime‘09/28/2008:21:03:11‘B.restoredatabasefilesuntiltime‘09/28/2008:18:00:00‘C.restoredatabaseuntiltime‘09/28/2008:18:00:00‘D.recoverdatabaseuntiltime‘09/28/2008:18:00:00‘E.recoverdatabaseuntiltimestamp‘09/28/2008:18:00:00‘
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）A、restore datafiles until time '09/28/2008:21:03:11'B、restore database files until time '09/28/2008:18:00:00'C、restore database until time '09/28/2008:18:00:00'D、recover database until time '09/28/2008:18:00:00'E、recover database until timestamp '09/28/2008:18:00:00'
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）A、backup database plus archivelogB、backup database plus archivlog until time ‘10:00‘C、backup database plus archivelog timeout ‘10:00‘D、backup database plus archivelog duration 10:00
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）A、Only the SET command must be within a RUN block.B、All commands should be executed at the RMAN prompt.C、All three commands must be within a single RUN block.D、Only the RESTORE and RECOVER commands must be within a single RUN block.
Which command would correctly start a TSPITR of the USERS tablespace？（） A、 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliaryB、 recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliaryC、 recover tablespace users to point-in.D、 recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliaryE、 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA、 b， d， eB、 b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 a， b， d， e
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（） A、 13：00 on Tuesday.B、 15：00 on Tuesday.C、 Up until the last available archived redo log on Sunday.D、 To any point； all the redo should still be available in the online redo logs.E、 The database is not recoverable.
What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A、 Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B、 The restore command will fail.C、 The recover command will fail.D、 The alter database open resetlogs command will fail.E、 All these commands will fail because they must be in the confines of a run block.
You manage a server that runs Windows Server 2008 R2.The D:/Payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00.You need to restore all the files in the D:/Payroll folder back to the most recent backup version without affecting other folders on the server.What should you do on the server？（）A、Run the Recover d:/payroll command.B、Run the Wbadmin restore catalog -backuptarget:D: -version:10/29/2007-09:00 quiet command.C、Run the Wbadmin start recovery -backuptarget:D: -version:10/29/2007-09:00 overwrite quiet command.D、Run the Wbadmin start recovery -version:10/29/2007-09:00 -itemType:File -items:d:/Payroll -overwrite -recursive quiet command.
You manage a server that runs Windows Server 2008. The D:///Payroll folder is corrupted. The most recent backup version is 10/29/2007-09：00. You need to restore all the files in the D:///Payroll folder back to the most recent backup version without affecting other folders on the server. What should you do on the server？（）A、 Run the Recover d：/Payroll comamndB、 Run the WBadmin restore catalog-backuptarget：D:// -version： 10/29/2007-09：00 Cquiet commandC、 Run the WBadmin start recovery-backuptarget：D:// -version： 10/29/2007-09：00 Coverwrite Cquiet commandD、 Run the Wbadmin start recovery-version：10/29/2007-09：00 -itemType：File -items d：/payroll -overwrite - recursive Cquiet command.
单选题You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A Start the database in the MOUNT stage.B Back up the control file to trace.C Set the DBIDD Issue the RECOVER DATABASE command.
单选题You manage a server that runs Windows Server 2008 R2.The D:/Payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00.You need to restore all the files in the D:/Payroll folder back to the most recent backup version without affecting other folders on the server.What should you do on the server？（）ARun the Recover d:/payroll command.BRun the Wbadmin restore catalog -backuptarget:D: -version:10/29/2007-09:00 quiet command.CRun the Wbadmin start recovery -backuptarget:D: -version:10/29/2007-09:00 overwrite quiet command.DRun the Wbadmin start recovery -version:10/29/2007-09:00 -itemType:File -items:d:/Payroll -overwrite -recursive quiet command.
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）AOnly the SET command must be within a RUN block.BAll commands should be executed at the RMAN prompt.CAll three commands must be within a single RUN block.DOnly the RESTORE and RECOVER commands must be within a single RUN block.
单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）A Restore all the datafiles from the backup.B Restore only the lost datafile from the backup.C Restore all the datafiles for the lost tablespace from the backup.D Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
单选题You manage a server that runs Windows Server 2008. The D:///Payroll folder is corrupted. The most recent backup version is 10/29/2007-09：00. You need to restore all the files in the D:///Payroll folder back to the most recent backup version without affecting other folders on the server. What should you do on the server？（）A Run the Recover d：/Payroll comamndB Run the WBadmin restore catalog-backuptarget：D:// -version： 10/29/2007-09：00 Cquiet commandC Run the WBadmin start recovery-backuptarget：D:// -version： 10/29/2007-09：00 Coverwrite Cquiet commandD Run the Wbadmin start recovery-version：10/29/2007-09：00 -itemType：File -items d：/payroll -overwrite - recursive Cquiet command.
单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）Abackup database plus archivelogBbackup database plus archivlog until time ‘10:00‘Cbackup database plus archivelog timeout ‘10:00‘Dbackup database plus archivelog duration 10:00
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B The restore command will fail.C The recover command will fail.D The alter database open resetlogs command will fail.E All these commands will fail because they must be in the confines of a run block.
单选题When running the tablespace point-in-time command recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name "USERS" What is the likely cause of the error?（）A The database is in ARCHIVELOG mode.B There is not a current backup of the database available.C The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.D The USERS tablespace is not eligible for TSPITR because it has invalid objects.E The recover tablespace command is incorrect and generates the error.
单选题Which command would correctly start a TSPITR of the USERS tablespace？（）A recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliaryB recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliaryC recover tablespace users to point-in.D recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliaryE recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
单选题Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（）A 13：00 on Tuesday.B 15：00 on Tuesday.C Up until the last available archived redo log on Sunday.D To any point； all the redo should still be available in the online redo logs.E The database is not recoverable.
单选题You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA b， d， eB b， d， fC c， a， b， d， eD c， a， b， d， fE a， b， d， e
单选题You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.