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.


相关考题: