You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropp

题目

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （）

A. A

B. B

C. C

D. D

相似考题

1.Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUsC. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaD. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

2.YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology，youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.Aftertheinstallation，youmakethefollowingchangesinyourinitializationparameterfile：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’DB_RECOVERY_FILE_DEST=’LOCATION=d：\product\10.1.0\flash_recovery_area’DB_RECOVERY_FILE_DEST_SIZE=10gWherearethearchivedredologsstoredforyourdatabase？（）

3.Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n

4.YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET

更多“You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery c ”相关问题

  • 第1题：

    ThedatabaseisrunninginARCHIVELOGmodeandtheFORMAToptionisnotconfiguredinRMANfordiskbackups.YouconfiguredtheflashrecoveryarealocationandsizebyusingtheDB_RECOVERY_FILE_DESTandDB_RECOVERY_FILE_DEST_SIZEinitializationparameters.Whichstatementiscorrectinthisscenario？（）

    A.IftheFORMAToptiontotheRMANBACKUPcommandisspecified，thenRMANcreatesbackuppiecesandimagecopiesintheflashrecoveryareawithnamesintheOracleManagedFiles（OMF）format.

    B.IfanylocaldestinationsforLOG_ARCHIVE_DEST_nareset，thenarchivedredologsarestoredinthesedestinationsaswellasintheflashrecoveryarea.

    C.IftheflashrecoveryarealocationisconfiguredusingtheDB_RECOVERY_FILE_DESTinitializationparameter，thentheRMANbackupofOraclemanageddatafiles（OMF）onlywillgototheflashrecoveryareabydefault.

    D.Ifnootherdestinationisconfiguredforrecoveryfiles，thenRMANplacesthecontrolfileautobackupsintheflashrecoveryareabydefault.


    参考答案：D

  • 第2题：

    下面哪2个参数是flashback databae必须设置的? ()

    A. DB_FLASHBACK_RETENTION_TARGET

    B. DB_RECOVERY_FILE_DEST

    C. RECOVERY_PARALLELISM

    D. FLASHBACK_TRANSACTION_QUERY

    E. DB_RECOVERY_FILE_DEST_SIZE


    参考答案BE

  • 第3题：

    毒理学研究中提倡3R原则是指

    A、replacement\reduction\refinement

    B、replacement\recovery\refinement

    C、replacement\reduction\reference

    D、replacement\recovery\reactivity

    E、replacement\recovery\reference


    参考答案：A

  • 第4题：

    Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()

    A.EXECUTE_CATALOG_ROLE

    B.CONNECT

    C.RESOURCE

    D.RECOVERY_CATALOG_OWNER

    E.RECOVERY_CATALOG_USER


    参考答案：D

  • 第5题：

    在对RMAN用户进行授权时,不需要授予的权限是()。

    A.CONNECT

    B.RECOVERY_CATALOG_OWNER

    C.DBA

    D.RESOURCE


    参考答案：C

  • 第6题：

    毒理学研究中提倡3R原则是指

    A.reptacement＼reduction＼refinement

    B.replacement＼recovery＼refinement

    C.replacement＼reduction＼reference

    D.replacement＼recovery＼reactivity

    E.replacement＼recovery＼reference


    正确答案：A

相关内容