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. AB. BC. CD. D

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


相关考题:

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

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

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?()

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

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.

Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?() A.EXECUTE_CATALOG_ROLEB.CONNECTC.RESOURCED.RECOVERY_CATALOG_OWNERE.RECOVERY_CATALOG_USER

下面哪2个参数是flashback databae必须设置的? () A. DB_FLASHBACK_RETENTION_TARGETB. DB_RECOVERY_FILE_DESTC. RECOVERY_PARALLELISMD. FLASHBACK_TRANSACTION_QUERYE. DB_RECOVERY_FILE_DEST_SIZE

在对RMAN用户进行授权时,不需要授予的权限是()。 A.CONNECTB.RECOVERY_CATALOG_OWNERC.DBAD.RESOURCE

毒理学研究中提倡3R原则是指A、replacement\reduction\refinementB、replacement\recovery\refinementC、replacement\reduction\referenceD、replacement\recovery\reactivityE、replacement\recovery\reference

毒理学研究中提倡3R原则是指A.reptacement\reduction\refinementB.replacement\recovery\refinementC.replacement\reduction\referenceD.replacement\recovery\reactivityE.replacement\recovery\reference