Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-0031

题目

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG

相似考题

1.You look(). What () you () ?A、tire, did…doB、tiring, have…doneC、tired, do…doD、tired, have…been doing

2.Where ________ you ________?A.are/beB.have/beC.is/beD.have/been

3.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

4.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

更多“Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which co ”相关问题

  • 第1题：

    Merry Christmas, George! Here is a card for ________, with ________ best withes.

    A.you…your

    B.you…our

    C.us…our

    D.us…your


    参考答案：B

  • 第2题：

    Yourdatabaseisinmanualarchivemode.Youronlineredologgroupsareconfiguredasfollows：

    YoudiscoverthatDISK3hasencounteredamediafailurethathasresultedinalossofallthemultiplexedcopiesofonlineredologfiles.

    YoudecidetodeletetheREDO01C.LOG，REDO02C.LOG，andREDO3C.LOGfilestopreventtheLGWRbackgroundprocessfromattemptingtoaccessthesefiles.WhenyouquerytheV$LOGdynamicview，youreceivethefollowingoutput：

    Whichsequenceofstatementsshouldyouusetodropthemissingonlineredologfilesfromthedatabase？（）

    1.ALTERDATABASEDROPLOGFILEMEMBER’E：\REDO01C.LOG’；

    2.ALTERSYSTEMSWITCHLOGFILE；

    3.ALTERDATABASEDROPLOGFILEMEMBER’E：\REDO03C.LOG’；

    4.ALTERSYSTEMARCHIVELOGGROUP3；

    5.ALTERDATABASEDROPLOGFILEMEMBER’E：\REDO02C.LOG’；

    6.ALTERSYSTEMARCHIVELOGGROUP1；


    参考答案：D

  • 第3题：

    （ ） – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A．your；my

    B．you；mine

    C．you；us

    D．your；us


    正确答案：D

  • 第4题：

    Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles？（）

    A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1；

    B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1；

    C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2；

    D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2；

    E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3；

    F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3；


    参考答案：A, C

  • 第5题：

    WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()

    A.TARGET_REDO_BLKS

    B.FAST_START_IO_TARGET

    C.LOG_CHECKPOINT_TIMEOUT

    D.RECOVERY_ESTIMATED_IOS

    E.LOG_FILE_SIZE_REDO_BLKS

    F.LOG_CHECKPOINT_INTERVAL


    参考答案：B, C, F

  • 第6题：

    You look（） What（）you（）?

    Atire；did；do

    Btiring；have；done

    Ctired；do；do

    Dtired；have；been doing


    D
    略

相关内容