题目内容

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

ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL&gThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL＞DESCv$FLASHBACK_DATABASE_STAT
NameNull？Type
-----------------------------------
BEGIN_TIMEDATE
END_TIMEDATE
FLASHBACK_DATANUMBER
DB_DATANUMBER
REDO_DATANUMBER
ESTIMATED_FLASHBACK_SIZENUMBER
WhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）