单选题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 d

题目
单选题
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'

相似考题

1.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.

2.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‘

3.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'

4.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

更多“单选题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 d”相关问题

  • 第1题：

    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 archivelog
    • B、backup database plus archivlog until time ‘10:00‘
    • C、backup database plus archivelog timeout ‘10:00‘
    • D、backup database plus archivelog duration 10:00

    正确答案:D

  • 第2题：

    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/auxiliary
    • B、 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/auxiliary
    • C、 recover tablespace users to point-in.
    • D、 recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
    • E、 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

    正确答案:E

  • 第3题：

    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 open

    • A、 b， d， e
    • B、 b， d， f
    • C、 c， a， b， d， e
    • D、 c， a， b， d， f
    • E、 a， b， d， e

    正确答案:A

  • 第4题：

    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 SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第5题：

    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.

    正确答案:D

  • 第6题：

    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 comamnd
    • B、 Run the WBadmin restore catalog-backuptarget：D:// -version： 10/29/2007-09：00 Cquiet command
    • C、 Run the WBadmin start recovery-backuptarget：D:// -version： 10/29/2007-09：00 Coverwrite Cquiet command
    • D、 Run the Wbadmin start recovery-version：10/29/2007-09：00 -itemType：File -items d：/payroll -overwrite - recursive Cquiet command.

    正确答案:D

  • 第7题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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 archivelog

    B

    backup database plus archivlog until time ‘10:00‘

    C

    backup database plus archivelog timeout ‘10:00‘

    D

    backup database plus archivelog duration 10:00


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:C

  • 第14题：

    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.

    正确答案:B

  • 第15题：

    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：       RMAN>BACKUP 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 DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第16题：

    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.

    正确答案:E

  • 第17题：

    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.

    正确答案:D

  • 第18题：

    单选题
    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：       RMAN>BACKUP 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 DBID

    D

     Issue the RECOVER DATABASE command.


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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 comamnd

    B

     Run the WBadmin restore catalog-backuptarget：D:// -version： 10/29/2007-09：00 Cquiet command

    C

     Run the WBadmin start recovery-backuptarget：D:// -version： 10/29/2007-09：00 Coverwrite Cquiet command

    D

     Run the Wbadmin start recovery-version：10/29/2007-09：00 -itemType：File -items d：/payroll -overwrite - recursive Cquiet command.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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/auxiliary

    B

     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/auxiliary

    C

     recover tablespace users to point-in.

    D

     recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

    E

     recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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 open
    A

     b， d， e

    B

     b， d， f

    C

     c， a， b， d， e

    D

     c， a， b， d， f

    E

     a， b， d， e


    正确答案： D
    解析： 暂无解析

相关内容