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

题目
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 recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

相似考题

1.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

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

3.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？（）

4.Youaretryingtorecoveryourdatabase.Duringtherecoveryprocess，youreceivethefollowingerror：ORA-00279：change5033391generatedat08/17/200806：37：40neededforthread1ORA-00289：suggestion：/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-00280：change5033391forthread1isinsequence#11ORA-00278：logfile，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_10_4bj6wnqm_.arcnolongerneededforthisrecoverySpecifylog：{=suggested|filename|AUTO|CANCEL}ORA-00308：cannotopenarchivedlog，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3Howdoyourespondtothiserror？（）

更多“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?() ”相关问题

  • 第1题：

    Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()

    A.QuerytheV$FLASHBACK_DATABASE_LOGview.

    B.QuerytheV$FLASHBACK_DATABASE_STATview.

    C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.

    D.QuerytheV$RECOVERY_FILE_DESTview.


    参考答案：B

  • 第2题：

    在OSPF协议中,核心的Area为()。

    A.Area0

    B.Area1

    C.Area2

    D.自定义


    答案A

  • 第3题：

    YouwouldliketocreateanRMANrecovercatalog&e

    YouwouldliketocreateanRMANrecovercataloginwhichtostoreinformationaboutyourDB01database.YouwanttousethedatabasenamedRCDBforthestorageofyourrecoverycatalog.Thesixstepsyouwillfollowtocreatearecovercatalogarenotdisplayedinthecorrectorder.Whichdisplaysthecorrectorder？（）

    1.Granttheappropriateprivileges（CONNECTandRESOURCE）androles

    （RECOVERY_CATALOG_OWNER）totheuserresponsibleforperformingbackupandrecoveroperations.

    2.Registerthetargetdatabaseinthecatalog.

    3.CreatethecatalogusingtheRMANcommandlineinterpreter.

    4.Createauserandschemawhichwillowntherecoverycatalog.

    5.CreatetablespacetoholdthecataloginthedatabaseyouhavededicatedforyourRMANrecoverycatalog.

    6.ConnecttothetargetdatabaseusingSYSDBAprivileges.


    参考答案：E

  • 第4题：

    YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）

    A.V$DATABASE

    B.V$FLASHBACK_DATABASE_STAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$RECOVERY_FILE_DEST


    参考答案：B

  • 第5题：

    下面哪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

  • 第6题：

    Youneedtorecoverfivedatafilesthatarespreadacrossmultipledisks.Whichinitializationparametershouldyousettospeedupredoapplication?()

    A.RECOVERY_PARALLELISM

    B.FAST_START_MTTR_TARGET

    C.LOG_CHECKPOINT_INTERVAL

    D.FAST_START_PARALLEL_ROLLBACK


    参考答案：A

相关内容