題庫(kù)解析答案更正

Whataretheprerequisitesforperformingflashbacktransactions?(Chooseallthatapply)A.SupplementallogmustbeenabledB.SupplementallogmustbeenabledfortheprimaryC.UndoretentionguaranteeforthedatabasemustbeD.EXECUTEpermissionontheDBMS_FLASHBACKpackagemustbegrantedtotheuserAnswer:ABD參考：要使用閃回回退事務(wù)處理功能，必須啟用補(bǔ)充記錄功能并建立正確的權(quán)限。例如，HR方案中的并在SQL*Plus中執(zhí)行以下設(shè)置步驟：alterdatabaseaddsupplementallogalterdatabaseaddsupplementallogdata(primarykey)columns;grantexecuteondbms_flashbacktohr;grantselectanytransactiontoWhicharethetwoprerequisitesbeforesettingupFlashbackDataArchive?(ChooseFlashrecoveryareamustbeUndoretentionguaranteemustbeDatabasemustberunninginarchivelogmode.E.ThetablespaceinwhichtheFlashbackDataArchiveiscreatedmusthaveautomaticsegmentspaceManagement(ASSM).Answer:A,錯(cuò)誤，閃回?cái)?shù)據(jù)歸檔跟 區(qū)沒(méi)有關(guān)系，閃回歸檔的數(shù)據(jù)是保存在閃回?cái)?shù)據(jù)表空間的數(shù)據(jù)文件里B,錯(cuò)誤，閃回?cái)?shù)據(jù)歸檔和undo數(shù)據(jù)沒(méi)關(guān)C,錯(cuò)誤，在非歸檔模式下也能創(chuàng)建閃回?cái)?shù)據(jù)歸檔D,正確，必須是自動(dòng)還原管 自動(dòng)管理下能創(chuàng)建成功，切換到手動(dòng)管理后，創(chuàng)建失敗WhichmodeofdatabaseshutdownrequiresaninstancerecoveryatthetimeofthenextdatabaseAnswer:WhichtwooperationsareNOTperformedbytheDUPLICATEcommandinRecoveryManager(RMAN)whileduplicatingarunningdatabase?(ChooseTwo)A.CreatingthecontrolfilefortheduplicatedatabaseB.RestoringthetargetdatafilestotheduplicatedatabaseC.PerformingcompleterecoveryusingallavailablebackupsE.CopyingtheonlineredologfilesfromthetargetdatabasetotheduplicatedatabaseAnswer:CE參考：LTEAN.（.從備還接）.載文件.的...ONT.的ID.過(guò)TOS.件注：數(shù)據(jù)庫(kù)過(guò)程在重新執(zhí)行時(shí)嘗試從故障點(diǎn)繼續(xù)Cn,算以N數(shù)TheenvironmentalvariableORACLE-BASEisset. YouwanttocheckthediagnosticfilescreatedaspartoftheAutomaticDiagnosticRepository(ADR).ViewtheExhibitandnotethevariousparameterssetinyourdatabase.WhatwillbethelocationoftheADRItissettoORACLE-ItissettoItissetto/u01/app/ItissettoAnswer: TheenvironmentalvariableORACLE-BASEissetIfenvironmentvariableORACLE_BASEissetDIAGNOSTIC_DESTissettothedirectorydesignatedbyORACLE_BASE.IdentifythescenariosinwhichtheRMANCROSSCHECKcommandisuseful.(ChooseallthatTocheckthattheobsoletebackupsaredeletedfromtherepositoryrecordsandfromthe youdeletearchivedredologswithoperatingsystemToupdateoutdatedinformationaboutbackupsthatdisappearedfromdiskortapeorbecamecorruptedandinaccessible.TosynchronizetheactualfilesondiskorinthemediamanagementcatalogwiththeRMANrepositoryforwhichthebackupwas nottakenusingRMAN. CrosschecksareusefulbecausetheycandotheUpdateoutdatedinformationaboutbackupsthatdisappearedfromdiskortapeorbecamecorruptedUpdatetherepositoryifyoudeletearchivedredologsorotherfileswithoperatingsystemYourproductiondatabaseitfunctionalontheSHOST1host.YouarebackinguptheproductiondatabasebyusingRecoveryManager(RMAN)withtherecoverycatalog.Youwanttoreplicatetheproductiondatabasetoantherhost,SHOST2,fortestingnewapplications.Afteryouensuredthatthebackupsofthetargetdatabaseareaccessibleonthenewhost,whatmustyoudotorestoreandrecoverthebackupforthetestenvironment?RestoringthecontrolfilefromthebackupbyusingtheNOCATALOGoptiontorestore,andrecoveringthedatafilesRestoringthedatafilesbyusingtheNOCATALOGoptionandusingtheSETNEWNAMEcommandtochangethelocationRestoringtheserverparameterfilefromthebackupbyusingtherecoverycatalogtorestore,andrecoveringthedatafilesRestoringthedatafilesfromthebackupbyusingtherecoverycatalogtorecoverthefiles,andusingtheSWITCHcommandtochangethelocation.Answer: 你產(chǎn)在SOT1你用mn復(fù) 來(lái)份產(chǎn)。想產(chǎn)到一主機(jī)上SHOST2試之你定新主上的標(biāo)據(jù)的備夠被么你須在測(cè)試還和復(fù)？atANnbdcnecttotetgettseihotcnecgtotereyag. C錯(cuò)D錯(cuò) fhefetsonhednonstmetupohehemephssheceho,hndonotuseTWMErhoelordoheepthsonheceho.B錯(cuò)誤YourdatabaseisrunninginARCHIVELOGmode.Youhavebeentakingbackupsofallthedatafilesandcontrolfilesregularly.YouareinformedthatsomeimportanttablesintheBILLINGtablespacehavebeendroppedonFebruary28,2007at10.30AMandmustberecovered.Youdecidetoperforman pleterecoveryusingthefollowingcommand:SQL>RECOVERDATABASEUNTILTIME‘2007-02-28:10:15:00’;IdentifythefilesthatmustberestoredtorecoverthemissingtablesRestorethebackupofallthedataRestorethebackupofall datafilesandthecontrolRestorethebackupofonlythedatafiles containthedroppedRestorethebackupofallthedatafilesbelongingtothetablespacecontainingthedroppedAnswer:你的數(shù)據(jù)庫(kù)運(yùn)行在歸檔模式，并且定期備份了所有的數(shù)據(jù)文件和控制文你決定使用以下命令執(zhí)行不完全恢復(fù)SQL>RECOVERDATABASEUNTILTIME‘2007-02-recoverdatabaserestoredatabserestore所有備份的AInyourtest-YouareusingRecoveryManager(RMAN)toperformincrementalbackupsofyourtest-ThetestdatabaseisrunninginNOARCHIVELOG-Oneofthedatafilesis-AllonlineredologfilesarelostbecauseofamediafailureWhichoptionmustyouconsiderinthisscenario?ConfiguringthedatabaseinARCHVIELOGmodeand thenusingincrementalbackuptorecoverthedatabaseUsingincrementalbackuptorecoverthedamageddatafileandthenmanuallycreatingtheonlineredologfilesCreatinganewtestdatabasebecause thedatabaseisnotrecoverableduetothefactthatthedatabaseisconfiguredinNOARCHIVELOGmodeUsingincrementalbackupstorecoverthedatabasebyusingtheRECOVERDATABASENOREDOcommandandthenusingtheRESETLOGSoptiontoopenthedatabase.Answer: 根據(jù)文檔，此題應(yīng)該選YouexecutethefollowingFLASHBACKTABLEWhichtwostatementsarecorrect?(ChooseTheEMPtablethatwasdropped mistakeearlierisTheFLASHBACKTABLEstatement executedasasingleTheFLASHBACKTABLEstatementdoesnotmaintainexistingindexesontheEMPThechangesmadetotheEMPtablesincethespecifiedtimeareundoneifnoconstraintisviolatedduringflashback.BDA，應(yīng)該使用FLASHBACKTABLE...TOBEFOREDROP來(lái)恢復(fù)，利用回收站原理。A錯(cuò) UsersareconnectedtoadatabaseinstancethatisusingAutomaticStorageManagement(ASM).TheDBAexecutesthecommandasfollowstoshutdowntheASMinstance:SQL>SHUTDOWNWhathappenstothedatabaseItshutsdownlongwiththeASMItisabortedandtheASMinstanceshutsdownItstaysopenandSHUTDOWNcommandfortheASMinstanceItshutsdownonlyafterallpendingtransactionsarecompletedandtheASMinstancewaitsforthisbeforeshuttingdown.Answer:參考 OracleASMwaitsforanyin-progressSQLtocompletebeforeperforminganorderlydismountofallofthediskgroupsandshuttingdowntheOracleASMinstance.OracleASMdoesnotwaitforuserscurrentlyconnectedtotheinstancetodisconnect.IfanydatabaseinstancesareconnectedtotheOracleASMinstance,thentheSHUTDOWNcommandreturnsanerrorandleavestheOracleASMinstancerunning.BecausetheOracleASMinstancedoesnotcontainanytransactions,theTRANSACTIONALmodebehavesthesameasIMMEDIATEmode.個(gè)人覺(jué)得這道應(yīng)該選WhichtwostatementsaretrueaboutthecompressedbackupsinRMAN?(Choosetwo.)pressedbackupscanonly betakenonthetapedrives.B.ThebinarycompressioncreatessomeperformanceoverheadduringbackupC.TheZLIBcompressionalgorithmcanbeusedonlyiftheCOMPATIBLEinitializationparameterissetto11.1.0.D.Themediamanagercompressionforthetapedriveshouldbeenabledfortakingcompressedbackupsonthetape.Answer:A錯(cuò)，也可以備份在disk上C錯(cuò)，onlyif Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcachecontainstheidealworkloadforysis.YouwanttoyzeonlyaWhatmustyoudotoreceive mendationsonefficientuseofindexesandmaterializedviewstoimprovequeryperformance?RuntheSQLAccessRuntheSQLTuningAdvisorRuntheAutomaticWorkloadRepository(AWR)RuntheAutomatic 參考 wantstoupgradetheproductiondatabasetoaRealApplicationClusters(RAC)environment.YousetupthebestRACdatabaseandwanttoreyarecordedworkloadcapturedtheproductiondatabaseonthetestThefollowingstepsmaybeused reythedatabasePreprocessthecapturedRestartthedatabaseinRESTRICTEDSetupReyRestorethetestdatabasetothepointwhenthecaptureRemapWhichisthecorrectsequenceoftherequiredsteps?A.1,4,3,5B.1,4,5,C.2,1,5,3,D.1,2,4,5,參考：個(gè)人覺(jué)得應(yīng)該選B.數(shù)據(jù)庫(kù)重放步驟捕獲工作量--預(yù)處理工作量--重放工作量--還原數(shù)據(jù) 連接映射--設(shè)置客戶機(jī)--分Whichtwostatementsaretrueaboutanimagecopybackup?(ChooseItmayonlybetakentoItwillcontainonlytheusedItwillcontainallusedandunusedItcanbeperformedondiskaswellasontape.Answer:ACWhentheASCOPYoptionisused,RMANgeneratesimagecopiesoftheinputfiles.Animagecopyabyte-for-byteidenticalcopyoftheoriginalfile.Youcancreateimagecopybackupsofdatafiles,datafilecopies,andarchivedredologfiles.ImagecopyfilescanonlyexistondiskAspartofarchivingthehistoricaldata,youwanttotransferdatafromonedatabasetoanotherdatabase,whichisonanotherserver.Alltablespacesinthesourcedatabaseareread/writeandThesourceandtargetdatabasesusethesame compatibilitylevelandcharactersets.ViewtheExhibitandexaminethefeaturesinthesourceandtargetdatabase.WhichofthefollowingstepsarerequiredtotransportatablespacefromthedatabasetothetargetMakethetablespaceread-onlyatthesourceExportmetadatafromthesourceConvertdatafiledbyusingRecoveryManagerTransferthedumpfileanddatafiledtothetargetImportmetadataatthetargetMakethetablespaceread/writeatthetargetA.2,4,andB.AllthestepsC.2,3,4andD.1,2,4,5andAnswer:答案選 12456（可選IdentifytwooptionsthatOracle mendswhileconfiguringthebackupandrecoveryenvironmentforyourrecoverycatalog.(Choosetwo.) fileautobackuptobebackingupdatafiledonlyandnotthearchivedredologrunningtherecoverycatalogdatabaseinNOARCHIVELOGsettingtheretentiontoaREDUNDANCYvaluegreaterthanbackinguptherecoverycatalogtothesamediskasthatof Answer:CD /cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADVExaminethefollowingcommandforRMANWhichstatementIstrueregardingtheapproachintheTheRMANmultiplexinglevelisItistheuseofasynchronousI/ObyItisacaseofparallelizationofthebackupItisanimplementationofamultisectionbackup.Answer:C從以上中以及以下的實(shí)驗(yàn)中看出，分了三個(gè)通道并行備份。圖中1,4,5數(shù)據(jù)文件使用通C1，2，3，9數(shù)據(jù)文件使用通道C2，6,7,8使用通道C3，這三個(gè)通道并行執(zhí)Inyourproductiondatabase,-AreusingRecoveryManager(RMAN)witharecoverycatalogtoperformthebackupoperationatregularintervals-Setthecontrolfileautobackupto-AremaintainingimagecopiesofthedatabaseYouhavelosttheserverparameterfile(SPFILE)andthecontrolfile.Which beforerestoringtheSPFILEandthecontrolfilebyusingthecontrolfileSettingDBIDfortheUsingtheRMANSWITCHUsingtheRMANSRTNEWNAMEStartingupthedatabaseinstanceintheNOMOUNTstateAnswer:D同32題一Yourdatabaseisusingadefaulttemporarytablespacethatcontainsthetemp01.tmptemporaryAlltheusersonthedatabaseusethedefaulttemporarytablspace.AuserissuesaqueryonthetableandreceivesthefollowingWhatwouldbethemostefficientwaytorectifythisAddanewtempfiletotheuser’stemporarytablespaceanddropthetempfile Shutdownthedatabaseinstance,restorethetemp01.tmpfilefromthebackup,andthenrestarttheAllowthedatabasetocontinuerunning,dropthetemp01.tmptemporaryfile,andthenre-createitwithnewtempfiles.Takethetemporarytablespaceoffline,recoverthemissingtempfilebyapplyingredologs,andthenbringthetemporarytablespaceonline.Answer:臨時(shí)文件在刪除后，數(shù)據(jù)庫(kù)再次啟動(dòng)時(shí)會(huì)自動(dòng)創(chuàng)建并且在數(shù)據(jù)庫(kù)運(yùn)行的過(guò)程中，使用rm刪除，并不影響排序的查詢 那個(gè)損壞的，就可以了AC的區(qū)別就是先刪除還是先增加？通過(guò)以下可知，當(dāng)只有一個(gè)臨時(shí)文件的時(shí)候，是不允許刪除的。故選A，此題答案有誤。Whichtwostatementsaretrue aboutaduplicatedatabasethatiscreatedby commandinRMAN?(ChooseItisacopyorasubsetofthetargetItisopenedinRESTRICTmodeafteraduplicatingItiscreatedbyusingbackupsandarchivedredologfilesfromthetargetItiscreatedwiththesamedatabaseidentifier(DBID)asthatoftargetAnswer:根據(jù)theDUPLICATEcommandautomaticallyassignstheduplicatedatabaseadifferentDBIDD錯(cuò)誤。OpenstheduplicatedatabasewiththeRESETLOGSoptionB錯(cuò)誤。參考：所以，正確答案應(yīng)該為ACAuserreceivesthefollowingerrorwhileperformingalargevolumeofinsertsintoaTheissueisresolvedbyincreasingthespacequotaontheUSERStablespacefortheuser.Butthemayperformsuchtransactioninthefuture.Youwanttoensurethatthecommandwaitsratherthanproduceanerrorwhensuchaneventoccursthenexttime.WhatcanyoudotoachievethisbeforerunningthecommandintheSetRESUMABLE_TIMEOUTfortheSettheRESOURCE_LIMITParametertoEnablethedatabaseinstancetouseasynchronousSettheLOG_CHECKPOINT_TIMEOUTparameter toanonzerovalueforthedatabaseinstance.Answer:C 根據(jù)文檔，此題選ViewtheExhibitandexaminetheparametersettingsinyourserver-sideparameterfileWhenyoutriedtostartthedatabaseinstance,youreceivedthefollowingWhydidtheinstancefailtoBecausetheSTATISTICS_LEVELparameterissettoBecauseboththeSGA_TARGETandMEMORY_TARGETparametersareAnswer: 以下實(shí)驗(yàn)說(shuō)明SGA_TARGETandMEMORY_TARGET可以同時(shí)set，而從文檔看SettingSGATargetSizeYouenabletheautomaticsharedmemorymanagementfeaturebysettingtheSGA_TARGETparametertoanonzerovalue.ThisparametersetsthetotalsizeoftheSGA.Itrecestheparametersthatcontrolthememoryallocatedforaspecificsetofindividualcomponents,whicharenowautomaticallyanddynamicallyresized(tuned)asneeded.TheSTATISTICS_LEVELinitializationparametermustbesettoTYPICAL(thedefault)orALLforautomaticsharedmemorymanagementtofunction.GivenbelowareRMANcommandstoenablebackupoptimizationand theretentionTheUSERStablespacehasneverbeenbackedup.YoutaketheUSERStablespaceofflineonViewtheExhibittoexaminetheoperationsperformedbyusingRMAN.WhichtwostatementsaretrueaboutthebackupoftheUSERStablespace?(Choosetwo.)ItwillbebackedupasapartofdatabasebackuponItwillbebackedupasapartofdatabasebackuponItwillnotbebackedupasapartofdatabasebackuponThecommandonSundaydeletesthebackupoftheUSERStablespacetakenonTuesday.Answer:AB從以下答案指導(dǎo)BD參考 ViewExhibit1toexaminetheDATAdiskgroupwhenallthedisksareWhyistherebalancingnotperformedandthecontent thediskgroupnotemptyinBecausethediskgroupiscreatedwithNORMALBecausethediskrepairtimeattributeissettoanonzeroBecausethemirroredextentscannotberebalancedacrosstheotherthreeBecausetheotherthreediskshave60%freespace,thediskrebalancingisdelayedAnswer:D途中對(duì)比，發(fā)現(xiàn)第二文件的path沒(méi)有了，題中問(wèn)為什么沒(méi)有重新平衡DISK_REPAIR_TIME參數(shù)，torepairthediskandbringitbackonline，推遲了重新平衡。B。YouexecutethefollowingcommandtosettheredundancyretentioninRecoveryManagerRMAN>CONFIGURERETENTIONTOREDUNDANCYIdentifythestatementthatcorrectlydescribestheimplicationsofthisA,whentherearealreadythreebackups,for backupRMANremovestheoldestB.Whentherearealreadythreebackups,forthe backupRMANmarkstheoldestbackupasC.thenumberofbackupsthatareretainedisequaltothreeanditincludesfull,incremental,andcumulativebackups.D.whentherearealreadythreebackup,oneoftheexistingbackups takingthe參考 BecauseofalogicalcorruptionintheEMPLOYEStables,youwanttoperformTablespacePoint-in-TimeRecovery(TSPITR)torecoverthetable.BeforeyoustartedtheTSPITRprocess,youqueriedtheTS_PITR_CHECKviewand yourealizedthatthetablehas DEPARTMENTSthatexistsinanothertablespace,MASTERTBS.WhichtwoactionswillpermittheTSPITRtowork?(ChooseDroptherelationshipbetweentheAddingtheMASTERTBStablespacetotherecoveryPuttingtheMASTERTBStablespaceinread-onlymodeAnswer:AD 個(gè)人覺(jué)得這道題應(yīng)該選BCIfconstraintsforthetablesintablespacetbs1arecontainedintablespacetbs2,thenyoucannotrecovertbs1withoutalsorecoveringtbs2.YouexecutedthefollowingConsideringthatalltheredologs areavailable,whatinformationcanyouderivefromtheoutputofThetimewhenthelastflashbackoperationinyourdatabasewasThetimewhenthefirstflashbackoperationinyourdatabasewasTheapproximatetimeandthelowestsystemchangenumber(SCN)to yourdatabaseThesystemchangenumber(SCN)andthetimewhentheFlashbackDatabasewasenabledinthedatabaseinstanceAnswer:題中問(wèn)：考慮到所有的重做日志可用，什么樣的信息可以來(lái)自上述查詢的輸出Adatabasehasthreeonlineredologgroupswithonemembereach.AredologmemberwiththestatusACTIVEisdamageswhilethedatabaseisrunning.WhatisthefirststepyoushouldtaketosolvethisAttempttoIssueaRestartthedatabaseusingtheRESETLOGSDroptheredolognumberandcreateitinadifferentPerform pleterecoveryuptothemostrecentavailableredoAnswer:參考 根據(jù)文檔，此題應(yīng)該選RecoveringAfterLosingAllMembersofanOnlineRedoLogIfamediafailuredamagesallmembersofanonlineredologgroup,thendifferentscenarioscanoccurdependingonthetypeofonlineredologgroupaffectedbythefailureandthearchivingmodeoftheIfthedamagedonlineredologgroupiscurrentandactive,thenitisneededforcrashrecovery;otherwise,itisnot.Table30-4outlinesthevariousrecoveryscenarios.Table30-4RecoveringAftertheLossofanOnlineRedoLogIfAndYouItisnotneededforcrashrecoveryItisneededforcrashAttempttoissueacheckpointandclearthelog;ifimpossible,thenyoumusteitheruseFlashbackDatabaseorrestoreabackupandperform pleterecoveryuptothemostrecentavailableredoItistheredologthat currentlywritingAttempttoclearthelog;ifimpossible,thenyoumusteitheruseFlashbackDatabaseorrestoreabackupandperform recoveryuptothemostrecentavailableredoYouexecutedthefollowingcommandsinadatabaseWhichstatementistrueaboutthecontentsofthe bininthisTheyremainTheyaremovedtoflashbackTheyaremovedtotheundoTheyaremovedtoatemporaryTheobjectsintherecyclebinthatareinthedefaulttablespaceforthesessionuserarecleanedAnswer:回收站中的對(duì)象在會(huì)話用戶的默認(rèn)表空間被清理掉了[oracle@rtest~]$oerrora01536,00000,"spacequotaexceededfortablespace// Thespacequotaforthesegmentownerinthetablespace beenexhaustedandtheope