YouareworkingonthePRODdatabase,whichisinNOARCHIVELOGmode.Youlosttheactiveonlineredologgroupduetoamediafailure.Howshouldyourecoveryourdatabase?() A.RestorethedatabasefromawholeconsistentbackupandstartthedatabaseinMOUNTmode.Then,openthedatabasewiththeRESETLOGSoptionafterperformingacancel-basedrecovery.B.RestorethedatabasefromawholeconsistentbackupandstartthedatabaseinMOUNTmode.Then,dropthelostredologgroupandopenthedatabasewiththeRESETLOGSoptionafterperformingacancel-basedrecovery.C.RestorethedatabasefromawholeconsistentbackupandstartthedatabaseinMOUNTmode.Then,clearthelostredologgroupandopenthedatabasewiththeRESETLOGSoptionafterperformingacancel-basedrecovery.D.Donothing.Youdonotneedtorecoverthedatabaseinthiscase;aninstancerecoverywillbeperformedbytheSMONprocessonstartup.
YouareworkingonthePRODdatabase,whichisinNOARCHIVELOGmode.Youlosttheactiveonlineredologgroupduetoamediafailure.Howshouldyourecoveryourdatabase?()
A.RestorethedatabasefromawholeconsistentbackupandstartthedatabaseinMOUNTmode.Then,openthedatabasewiththeRESETLOGSoptionafterperformingacancel-basedrecovery.
B.RestorethedatabasefromawholeconsistentbackupandstartthedatabaseinMOUNTmode.Then,dropthelostredologgroupandopenthedatabasewiththeRESETLOGSoptionafterperformingacancel-basedrecovery.
C.RestorethedatabasefromawholeconsistentbackupandstartthedatabaseinMOUNTmode.Then,clearthelostredologgroupandopenthedatabasewiththeRESETLOGSoptionafterperformingacancel-basedrecovery.
D.Donothing.Youdonotneedtorecoverthedatabaseinthiscase;aninstancerecoverywillbeperformedbytheSMONprocessonstartup.