题目内容

YourdatabaseisrunninginNOARCHIVELOGmodewithtwoonlineredologfiles.TheSALEStablecontainssalesinformationfortheorganization.TheSALEStablebelongstotheSALESTBtablespace.OnMonday，youinsert10rowsintotheSALEStable.Thecurrentlogsequencenumberis14.YouchangethetablespacestatusfromREADWRITEtoREADONLYfortheSALESTBtablespace.YoushutdownthedatabaseandtakeabackupoftheSALESTBtablespace.
OnTuesday，youstartthedatabase.YouchangethestatusfortheSALESTBtablespacefromREADONLYtoREADWRITE.Youinsert10morerowsintotheSALEStableandshutdownthedatabase.Thecurrentlogsequencenumberis15.
WhenyoutrytoopenthedatabaseonWednesdaymorning，youdiscoverthattheSALESTBtablespacewaslostbecauseofamediafailure.WhichofthefollowingoptionsistrueaboutrecoveringtheSALEStable？（）

查看答案

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

更多问题

园林植物病害（名词解释)

围蛹（名词解释)

YourdatabaseisinARCHIVELOGmode.OnFridayevening，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethe
database.OnMonday，theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles，HR1.DBFandHR2.DBF，bothofwhichbelongtoaread/writetablespacenamedHR.Thediskalsocontainsadatafile，USERS.DBF，whichbelongstoaread/writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase，youissuethefollowingRMANcommands：
RMAN＞RESTOREDATABASE；
RMAN＞RECOVERDATABASE；
AftersuccessfullyexecutingtheseRMANcommands，youissuethefollowingstatementusingSQL*Plus：
SQL＞ALTERDATABASEOPEN；
Youreceivethefollowingerrorswhenattemptingtoopenthedatabase：
ORA-01157：cannotidentify/lockdatafile10seeDBWRtracefile
ORA-01110：datafile10：’D：\USERS.DBF’
Whatisthecauseoftheseerrors？（）

同主寄生（名词解释)