网友您好, 请在下方输入框内输入要搜索的题目:
Yourdatabaseisinmanualarchivemode.Youronlineredologgroupsareconfiguredasfollows:
YoudiscoverthatDISK3hasencounteredamediafailurethathasresultedinalossofallthemultiplexedcopiesofonlineredologfiles.
YoudecidetodeletetheREDO01C.LOG,REDO02C.LOG,andREDO3C.LOGfilestopreventtheLGWRbackgroundprocessfromattemptingtoaccessthesefiles.WhenyouquerytheV$LOGdynamicview,youreceivethefollowingoutput:
Whichsequenceofstatementsshouldyouusetodropthemissingonlineredologfilesfromthedatabase?()
1.ALTERDATABASEDROPLOGFILEMEMBER’E:\REDO01C.LOG’;
2.ALTERSYSTEMSWITCHLOGFILE;
3.ALTERDATABASEDROPLOGFILEMEMBER’E:\REDO03C.LOG’;
4.ALTERSYSTEMARCHIVELOGGROUP3;
5.ALTERDATABASEDROPLOGFILEMEMBER’E:\REDO02C.LOG’;
6.ALTERSYSTEMARCHIVELOGGROUP1;
参考答案