题目内容

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？（）

查看答案

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

更多问题

同主寄生（名词解释)

非专性寄生（名词解释)

颉颃作用（名词解释)

YouarepartoftheDBAteamworkingforamultinationalbank.Theteamisresponsibleforperformingadministrativetasksonthedatabaseserverlocatedatthehomeoffice.ThedatabaseserveratthehomeofficehasaproductiondatabaseandatestdatabasenamedTESTDB.Thetestdatabaseisprimarilyusedfortestingdatabasecommandsandconfigurationsettingsbeforimplementingthesesettingsontheproductiondatabase.Thetestdatabaseisalsousedforthedevelopmentofdatabaseapplications.YouhavebeenaskedbytheseniorDBAtogranttheSYSDBAprivilegetoanewteammember，John，sothathecanperformsomeadministrativetasks，suchasshutdownandstartupoperations，onTESTDB.YouusethepasswordfiletoconfigureremoteauthenticationontheTESTDBdatabase.Youexecutethefollowingstatementtograntthe SYSDBAprivilegetoJohn：
SQL＞GRANTSYSDBATOjohn；
However，youreceivethefollowingerror：
ORA-01996：GRANTfailed：passwordfile
’c：\oracle\ora9i\dbs\testdb.pwd’isfull
Whichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers？（）