You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up ve

题目

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk.Proactively, which two options could you use to make more space available in the flash recovery？（）

A. Change the RMAN archived log deletion policy

B. Use the RMAN CROSSCHECK command to reclaim the archived log space

C. Change the RMAN retention policy to retain backups for a shorter period of time

D. Use OS command to move files from the flash recovery area to some other location

相似考题

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

更多“You are using the flash recovery area (fast recovery area in 11g Release 2) to store backu ”相关问题

  • 第1题：

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

    A.Area0

    B.Area1

    C.Area2

    D.自定义


    答案A

  • 第2题：

    Youneedtorecoverfivedatafilesthatarespreadacrossmultipledisks.Whichinitializationparametershouldyousettospeedupredoapplication?()

    A.RECOVERY_PARALLELISM

    B.FAST_START_MTTR_TARGET

    C.LOG_CHECKPOINT_INTERVAL

    D.FAST_START_PARALLEL_ROLLBACK


    参考答案：A

  • 第3题：

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

    A、replacement\reduction\refinement

    B、replacement\recovery\refinement

    C、replacement\reduction\reference

    D、replacement\recovery\reactivity

    E、replacement\recovery\reference


    参考答案：A

  • 第4题：

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

  • 第5题：

    WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()

    A.TARGET_REDO_BLKS

    B.FAST_START_IO_TARGET

    C.LOG_CHECKPOINT_TIMEOUT

    D.RECOVERY_ESTIMATED_IOS

    E.LOG_FILE_SIZE_REDO_BLKS

    F.LOG_CHECKPOINT_INTERVAL


    参考答案：B, C, F

  • 第6题：

    配置OSPF路由，必须需要具有的网络区域是：

    A．Area0

    B．Area1

    C．Area2

    D．Area3


    Area0

相关内容