niusouti.com

Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.Whichtwostatementswillyo

题目

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；

相似考题

1.You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

2.Williamspecifiedthefollowinginitializationparametersettingsinthepfile：BACKGROUND_DUMP_DEST=’u01\oradata\dir_A’USER_DUMP_DEST=’u01\oradata\dir_B’DB_CREATE_FILE_DEST=’u01\oradata\dir_C’DB_CREATE_ONLINE_LOG_DEST_n=’u01\oradata\dir_D’Williamenabledthechange-trackingfeaturebecausehedoesnotwanttoscantheentiredatafileduringbackup.Whatisthedefaultstoragelocationforthechangetrackingfile？（）A.’u01\oradata\dir_A’B.’u01\oradata\dir_B’C.’u01\oradata\dir_C’D.’u01\oradata\dir_D’

3.Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOGMAXLOGFILES20MAXLOGMEMBERS3MAXDATAFILES30MAXINSTANCES10MAXLOGHISTORY1200LOGFILEGROUP1（’/disk1/prod/orders/db/log1a.dbf’，’/disk2/prod/orders/db/log1b.dbf’）SIZE100KGROUP2（’/disk1/prod/orders/db/log2a.dbf’，’/disk2/prod/orders/db/log2b.dbf’）SIZE100K，DATAFILE’/disk1/prod/orders/db/database1.dbf’，’/disk2/prod/orders/db/file1.dbf’；

4.Youhavelostallyouronlineredologs.Asaresult，yourdatabasehascrashed.Youhavetriedtorestartthedatabaseandcleartheonlineredologfiles，butwhenyoutrytoopenthedatabaseyougetthefollowingerror.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea167395328bytesFixedSize1298612bytesVariableSize142610252bytesDatabaseBuffers20971520bytesRedoBuffers2514944bytesDatabasemounted.ORA-00313：openfailedformembersofloggroup2ofthread1ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3SQL>alterdatabaseclearlogfilegroup2；alterdatabaseclearlogfilegroup2*ERRORatline1：ORA-01624：log2neededforcrashrecoveryofinstanceorcl（thread1）ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02.logORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.logWhatstepsmustyoutaketoresolvetheerror？（）a.Issuetherecoverdatabaseredologscommand.b.IssuetheStartupMountcommandtomountthedatabase.c.Restorethelastfulldatabasebackup.d.Performapoint-in-timerecovery，applyingallarchivedredologsthatareavailable.e.Restoreallarchivedredologsgeneratedduringandafterthelastfulldatabasebackup.f.Openthedatabaseusingthealterdatabaseopenresetlogscommand.g.Issuethealterdatabaseopencommand.

更多“Youhavethefollowingonlineredologconfiguration:GroupMember1’／disk1／oradata／redo01a.log’2’／d ”相关问题

  • 第1题：

    Youareoperatingyourdatabaseinthemanualarchivingmode.Currently，yourdatabaseisconfiguredwiththefollowingonlineredologgroupsandmembers：YoutriedtodropGroup1fromthedatabasebutreceivedthefollowingerrors：ORA-01623：log1iscurrentlogforthread1cannotdropORA-00312：onlinelog1thread1：’D：\ORACLE\ORADATA\TESTDB\REDO01a.LOG’Whatmightbethereasonfortheseerrors？（）

    A.Group1isanactiveorcurrentonlineredologgroup.

    B.Group1isaninactiveonlineredogroupthathasnotbeenarchivedyet.

    C.ThemembersoftheGroup1aretemporarilyasymmetricwiththemembersofothergroups.

    D.ThesizeoftheonlineredologmembersofGroup1isdifferentfromthesizeofthemembersinothergroups.


    参考答案：A

  • 第2题：

    Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()

    A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.

    B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.

    C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.

    D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.


    参考答案：C

  • 第3题：

    Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）

    A.A

    B.B

    C.C

    D.D


    参考答案：D

  • 第4题：

    ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）

    A.Itwillbecreatedonthelocalfilesystem.

    B.ItwillbecreatedonlyintheFlashRecoveryArea.

    C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.

    D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.


    参考答案：A

  • 第5题：

    You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE = ‘/u01/oradata’Which statement is true about the archived redo log files?（）

    A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

    B. They are created only in the Fast Recovery Area.

    C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

    D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


    参考答案：B

相关内容