题目内容

YouworkasadatabaseadministratorforCertkiller.com.UsersintheCertkillerPRODdatabasecomplainabouttheslowresponsewhenaccessingthedatabase.IntheActiveSessionWaiting：Configurationpageyoufindthatthemajorityofthewaittimeisfortheredologbuffer.FurtherinvestigationusingtheRunQueuegraphandoperatingsystemtoolsrevealsthattheredologfilesareonthesamedisks，andthatthediskI/Ofortheredologfilesisthereasonfortheperformancedegradation.
Whichtwoactionswouldyoutaketogainperformance？（）

查看答案

搜索结果不匹配？点我反馈

更多问题

Yousettherecoverywindowtosevendays

YourdatabaseoperatesinARCHIVELOGmode.Theredologfilesarenotmultiplexedandoneoftheonlineredologsismissing.Themissingredologsequence，230，isnotarchivedanditcontainedinformationfrom10：35a.m.onwards.Thecurrenttimeis11：00a.m.Becauseofadiskcrash，youexecutedthefollowingcommandtoperformanincompleterecovery：
RMAN＞RUN{
2＞SETUNTILSEQUENCE230THREAD1；
3＞ALTERDATABASEMOUNT；
4＞RESTOREDATABASE；
5＞RECOVERDATABASE；
6＞ALTERDATABASEOPENRESETLOGS；
7＞}；
Withreferencetothisscenario，whichstatementistrue？（）

ThedatabaseinstanceiscurrentlyusingSPFILE.ViewtheExhibitandexaminetheerrorthatyoureceivedwhilerunningtheDBStructureIntegritycheck.
Givenbelowarethestepstorecoverfromtheerrorinrandomorder:
1:Shutdowntheinstance,ifnotalreadydone.
2:Copyoneoftheremainingcontrolfilestoanewlocation.
3:ChangethevalueoftheCONTROL_FILESinitializationparametertocorrespondtothenewlocationofthecontrolfiles.
4:StartupthedatabaseinstancetotheNOMOUNTstage.
5:Recoverthedatabasetothepointoffailureofthecontrolfile.
6:Openthedatabase.
Identifythecorrectsequenceofsteps()

YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalogschemaownedbytheuserRCAT10.
YouwanttheRMANtoimportmetadatafordatabaseIDs1423241and1423242，registeredinRCAT10，intotherecoverycatalogownedbyRCO11.Youexecutedthefollowingcommands：RMAN＞CONNECTCATALOGrco11/password@catdb
RMAN＞IMPORTCATALOGrcat10/oracle@inst1NOUNREGISTER；
Whichtwostatementsaretrueregardingthetasksaccomplishedwiththesecommands？（）