YourdatabaseisinARCHIVELOGmode.OnFridayevening,youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager(RMAN)promptandclosethedatabase.OnMonday,theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles,HR1.DBFandHR2.DBF,bothofwhichbelongtoaread/writetablespacenamedHR.Thediskalsocontainsadatafile,USERS.DBF,whichbelongstoaread/writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase,youissuethefollowingRMANcommands:RMANRESTOREDATABASE;RMANRECOVERDATABASE;AftersuccessfullyexecutingtheseRMANcommands,youissuethefollowingstatementusingSQL*Plus:SQLALTERDATABASEOPEN;Youreceivethefollowingerrorswhenattemptingtoopenthedatabase:ORA-01157:cannotidentify/lockdatafile10seeDBWRtracefileORA-01110:datafile10:’D:\USERS.DBF’Whatisthecauseoftheseerrors?()

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?()


相关考题:

2A级保养新增的内容包括()。 A.更换空气滤清器B.润滑车门铰链C.检查变速箱油D.更换火花塞

拍卖国有资产,依照法律或者按照国务院规定需要评估的,应当经依法设立的评估机构评估,并根据评估结果确定拍卖标的的保留价。() 此题为判断题(对,错)。

3岁宝宝能做到下列哪些( ) A、经过您的示范后,宝宝可以跟随您的指令向上或向下拉拉链B、宝宝可以回答自己的全名或学名C、宝宝站立时,可以只用一只手把小球举过肩然后向前扔出去D、宝宝可以双脚同时离地向前跳至少15厘米

码头附近水深足够,水域较宽时,采用( )。 A、开首驶离B、开尾驶离C、平移驶离D、以上说法都不正确

COS_T系统待处理业务可使用业务冲正功能进行冲正处理。() 此题为判断题(对,错)。

变压器的上层油温一般应在()以下。 A.75℃B.85℃C.90℃D.95℃

下列属于古代官学形式的是()。 A、太学B、国子学C、府州县学D、书院

Everyone feels ________ at being treated unfairly. A.antiqueB.applicationC.treatmentD.resentment

下面关于图层蒙版的描述不正确的是()。 A.不可在图层蒙版上直接调整色调B.图层蒙版分为普通的图层蒙版和矢量蒙版两类C.图层蒙版实际上是一幅256色的灰度图像D.可以将蒙版转换为选区

当高清终端需要进行点对点呼叫时可以选择哪项进入呼叫?() A.呼叫B.诊断C.设置D.应用功能