网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Whenyoutrytoopenyourdatabase,youreceivethefollowingerror:ORA-00205:errorinidentifyingcontrolfileWherewouldyoufindthedetailsrequiredtoresolvethiserror?()
A.audittrail
B.alertlogfile
C.usertracefile
D.onlinetracefile
E.backgroundtracefile
F.operatingsystemeventviewer
参考答案
更多 “ Whenyoutrytoopenyourdatabase,youreceivethefollowingerror:ORA-00205:errorinidentifyingcontrolfileWherewouldyoufindthedetailsrequiredtoresolvethiserror?() A.audittrailB.alertlogfileC.usertracefileD.onlinetracefileE.backgroundtracefileF.operatingsystemeventviewer ” 相关考题
考题
Youaretryingtorecoveryourdatabase.Duringtherecoveryprocess,youreceivethefollowingerror:ORA-00279:change5033391generatedat08/17/200806:37:40neededforthread1ORA-00289:suggestion:/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-00280:change5033391forthread1isinsequence#11ORA-00278:logfile,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_10_4bj6wnqm_.arcnolongerneededforthisrecoverySpecifylog:{=suggested|filename|AUTO|CANCEL}ORA-00308:cannotopenarchivedlog,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3Howdoyourespondtothiserror?()
考题
Whenrunningthetablespacepoint-in-timecommandrecovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary;youreceivethefollowingerror:RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat10/08/200816:00:30RMAN-20202:TablespacenotfoundintherecoverycatalogRMAN-06019:couldnottranslatetablespacenameUSERSWhatisthelikelycauseoftheerror?()A.ThedatabaseisinARCHIVELOGmode.B.Thereisnotacurrentbackupofthedatabaseavailable.C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.E.Therecovertablespacecommandisincorrectandgeneratestheerror.
考题
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?()A. 1,6,5,4,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered
考题
Whileworkingonthedatabase,youreceivethefollowingerror:01578:ORACLEdatablockcorrupted(file6,block54)ORA-01110:datafile6:’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery?()A.BlockMediaRecoverymustbeusedwithRMAN.B.Youmustperformcompleterecoveryofindividualblocks.C.YoumusthaveafullRMANbackup,notanincrementalbackup.D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.
考题
Youissuethefollowingstatement:SQLSELECTFIRSTNAME,LASTNAMEFROMHR.EMPLOYEE;Youreceivethefollowingerror:01578:ORACLEdatablockcorrupted(file6,block54)ORA-01110:datafile6:’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover(MTTR)?()A.byusingtheDBMS_REPAIRpackageB.byusingtheDBVERIFYutilityC.byusingBlockMediaRecoveryD.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand
考题
Youreceivethefollowingerror:ORA-19804:cannotreclaimnnnnnbytesdiskspacefrommmmmmlimitIdentifythereasonforreceivingtheaboveerrormessage?()
A.Thesortareaisverysmall.B.ThereisnomorespaceintheUndotablespace.C.Theflashrecoveryareaisfull.D.Theonlineredologfileisfull.
考题
YouareaDatabaseAdministratorwithWonderWeb.You&en
YouareaDatabaseAdministratorwithWonderWeb.YouuseapasswordfiletoestablishconnectionstotheSalesdatabaselocatedontheserver.Youcreatedthepasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=adminentries=4Youerroneouslydeletedthepasswordfilewhilethedatabasewasrunning.Youre-createthepasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=change_on_installentries=4However,whenyoutrytoconnectastheSYSuser,youreceivethefollowingerror:ORA-01031:insufficientprivilegesWhatshouldyoudotoresolvethiserror?()
考题
YouarepartoftheDBAteamworkingforaGRANTSYSDBATOjohn;However,youreceivethefollowingerror:ORA-01996:GRANTfailed:passwordfile’c:\oracle\ora9i\dbs\testdb.pwd’isfullWhichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers?()
热门标签
最新试卷