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

题目
Youreceivedthefollowingerror:ORA－01578:ORACLEdatablockcorrupted(file%s,block%s)Whichfilewillyouchecktoviewadditionalinformationregardingthecauseofthiserror?()

A.thealertlogfileandthetracefiles

B.theredologfiles

C.thecontrolfile

D.thechangetrackingfile

相似考题

1.YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT="$ORACLE_SID_%s_%t.%t"DB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD？（）A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST

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

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

更多“Youreceivedthefollowingerror:ORA－01578:ORACLEdatablockcorrupted(file%s,block%s)Whichfilewillyouchecktoviewadditionalinformationregardingthecauseofthiserror?() ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    标准库函数fgets(s,n,file)的功能是( )。A.从文件file中读取长度为n的字符串存入字符数组S由S

    标准库函数fgets（s，n，file）的功能是（ ）。

    A.从文件file中读取长度为n的字符串存入字符数组S由

    B.从文件file中读取长度不超过n-1个字符的字符串放到字符数组S中

    C.从文件file中读到n个字符串存入字符数组s中

    D.从文件file中读取长度为n-1个字符的字符串存人字符数组s中


    正确答案：B
    本题考查fgets()函数的使用调用形式：fgets(S，n，fp)。fgets函数参数说明：“s”可以是一个字符数组名，也可以是指向字符串的指针；“n”为要读取的最多的字符个数；“fp”是指向该文件型指针。fgets函数的功能是：从fp所指向的文件中读取长度不超过n-1个字符的字符串，并将该字符串放到字符数组s中，读入字符串后会自动在字符串末尾加入″＼0″结束符。表示字符串结束。

  • 第4题：

    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

  • 第5题：

    标准库函数fgets(s,n,file)的功能是( )。A.从文件file中读取长度为n的字符串存入字符数s由 SXB

    标准库函数fgets(s，n，file)的功能是( )。

    A.从文件file中读取长度为n的字符串存入字符数s由

    B.从文件file中读取长度不超过n-1个字符的字符放到字符数组S中

    C.从文件file中读到n个字符串存入字符数组s中

    D.从文件file中读取长度为n-1个字符的字符串存字符数组S中


    正确答案：B
    本题考查fgets函数的使用调用形式：fgets(s，n，fp)。fgets函数参数说明：“S”可以是一个字符数组名，也可以是指向字符串的指针；“n”为要读取的最多的字符个数；“fp”是指向该文件型指针。fgets函数的功能是：从fp所指向的文件中读取长度不超过n-1个字符的字符串，并将该字符串放到字符数组S中，读入字符串后会自动在字符串末尾加入"＼0"结束符，表示字符串结束。

相关内容