Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageof

题目

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.

相似考题

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

2.Youreceivedthefollowingerror:ORA－01578:ORACLEdatablockcorrupted(file%s,block%s)Whichfilewillyouchecktoviewadditionalinformationregardingthecauseofthiserror?()A.thealertlogfileandthetracefilesB.theredologfilesC.thecontrolfileD.thechangetrackingfile

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

4.YouissuedthefollowingcommandtoanalyzetheSCOTT.EMPtableforblockcorruption：ANALYZETABLESCOTT.EMPVALIDATESTRUCTURE；Youreceivedthefollowingerror：ORA-01578：ORACLEdatablockcorrupted（file%s，block%s）Howwillyouresolvetheblockcorruptionproblem？（）A.byusingtheDBMS_REPAIRpackageB.byusingtheDB_BLOCK_CHECKINGparameterC.byusingtheDBVERIFYutilityD.willnotbecompletelyresolveduntilthehardwarefaultiscorrected

更多“Whileworkingonthedatabase,youreceivethefollowingerror:01578:ORACLEdatablockcorrupted(file6 ”相关问题

  • 第1题：

    Youreceivethefollowingerror:ORA－19804:cannotreclaimnnnnnbytesdiskspacefrommmmmmlimitIdentifythereasonforreceivingtheaboveerrormessage?()

    A.Thesortareaisverysmall.

    B.ThereisnomorespaceintheUndotablespace.

    C.Theflashrecoveryareaisfull.

    D.Theonlineredologfileisfull.


    参考答案：C

  • 第2题：

    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

  • 第3题：

    YouworkasadatabaseadministratoratCertkiller&ensp

    YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：

    01578：ORACLEdatablockcorrupted（file#5，block#51）

    ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’

    Youneedtorectifythecorruptionwhileensuringthefollowing：

    Thedatafileshouldremainonline.

    Themeantimetorecover（MTTR）shouldbeminimal.

    Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.

    Whichoptionwouldyouchoose？（）


    参考答案：D

  • 第4题：

    Identifythetwosituationsinwhichthealertlogfileisupdatedwithdetails.()

    A.Runningaqueryonatablereturns"ORA-600：InternalError."

    B.Insertingavalueinatablereturns"ORA-01722：invalidnumber."

    C.Creatingatablereturns"ORA-00955：nameisalreadyusedbyanexistingobject."

    D.Insertingavalueinatablereturns"ORA-00001：uniqueconstraint（SYS.PK_TECHP）violated."

    E.RebuildinganindexusingALTERINDEX...REBUILDfailswithanerror"ORA-01578：ORACLEdatablockcorrupted（file#14，block#50）.


    参考答案：A, E

  • 第5题：

    Identify two situations in which the alert log file is updated.()

    A. Running a query on a table returns ORA-600: Internal Error.

    B. Inserting a value into a table returns ORA-01722: invalid number.

    C. Creating a table returns ORA-00955: name us already in used by an existing objects.

    D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

    E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.


    参考答案：A, E

相关内容