Whenyoutrytoopenyourdatabase,youreceivethefollowingerror:ORA－00205:errorinidentifyingcontrolfileWherewouldyoufindthedetailsrequiredtoresolvethiserror?()A.audittrailB.alertlogfileC.usertracefileD.onlinetracefileE.backgroundtracefileF.operatingsystemeventvi

题目
Whenyoutrytoopenyourdatabase,youreceivethefollowingerror:ORA－00205:errorinidentifyingcontrolfileWherewouldyoufindthedetailsrequiredtoresolvethiserror?()

A.audittrail

B.alertlogfile

C.usertracefile

D.onlinetracefile

E.backgroundtracefile

F.operatingsystemeventviewer

相似考题

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

2.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

3.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.

4.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:couldnottranslatetablespacename"USERS"Whatisthelikelycauseoftheerror?（）A.ThedatabaseisinARCHIVELOGmode.B.Thereisnotacurrentbackupofthedatabaseavailable.C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.E.Therecovertablespacecommandisincorrectandgeneratestheerror.

更多“Whenyoutrytoopenyourdatabase,youreceivethefollowingerror:ORA－00205:errorinidentifyingcontrolfileWherewouldyoufindthedetailsrequiredtoresolvethiserror?() ”相关问题

  • 第1题：

    Youissuethefollowingstatement：SQL>SELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）

    A.byusingtheDBMS_REPAIRpackage

    B.byusingtheDBVERIFYutility

    C.byusingBlockMediaRecovery

    D.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand


    参考答案：C

  • 第2题：

    YouareaDatabaseAdministratorwithWonderWeb.You&en

    YouareaDatabaseAdministratorwithWonderWeb.YouuseapasswordfiletoestablishconnectionstotheSalesdatabaselocatedontheserver.Youcreatedthepasswordfileusingthefollowingcommand：

    ORAPWDfile=d：\oracle\ora9i\orapwU01password=adminentries=4

    Youerroneouslydeletedthepasswordfilewhilethedatabasewasrunning.Youre-createthepasswordfileusingthefollowingcommand：

    ORAPWDfile=d：\oracle\ora9i\orapwU01password=change_on_installentries=4

    However，whenyoutrytoconnectastheSYSuser，youreceivethefollowingerror：

    ORA-01031：insufficientprivileges

    Whatshouldyoudotoresolvethiserror？（）


    参考答案：D

  • 第3题：

    Youreceivethefollowingerror:ORA－19804:cannotreclaimnnnnnbytesdiskspacefrommmmmmlimitIdentifythereasonforreceivingtheaboveerrormessage?()

    A.Thesortareaisverysmall.

    B.ThereisnomorespaceintheUndotablespace.

    C.Theflashrecoveryareaisfull.

    D.Theonlineredologfileisfull.


    参考答案：C

  • 第4题：

    YouarepartoftheDBAteamworkingfora&en

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


    参考答案：B

相关内容