You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo

题目

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

A. Open the database in NORMAL mode

B. Open the database in read-only mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

相似考题

1.当端口由于违规操作而进入“err－disableb”状态后,使用什么命令手工将其恢复为UP状态?()A.errdisable recoveryB.no shutdownC.recovery reedisableD.recovery

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.Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()A.RECOVERY_CATALOG_OWNERB.DBAC.RESOURCED.SELECTANYDICTIONARYE.CONNECT

更多“You are using recovery Manager (RMAN) with a recovery catalog to backup up your production ”相关问题

  • 第1题：

    Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()

    A.EXECUTE_CATALOG_ROLE

    B.CONNECT

    C.RESOURCE

    D.RECOVERY_CATALOG_OWNER

    E.RECOVERY_CATALOG_USER


    参考答案：D

  • 第2题：

    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

  • 第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题：

    在对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

相关内容