题目内容（请给出正确答案）

[主观题]

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which co

ntains one redo member. When you attempt to start the database, you receive the following errors:Which statement should you use to resolve this issue？（）

Your database is in ARCHIVELOG mode. You have two

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‘;

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“Your database is in ARCHIVELOG…”相关的问题

第1题

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

点击查看答案

第2题

YourdatabaseisinARCHIVELOGmode.Youhavetwoonlineredologgroups，eachofwhichcontainsoneredomember.Whenyouattempttostartthedatabase，youreceivethefollowingerrors：（）

A.ALTERDATABASEDROPLOGFILEGROUP1

B.ALTERDATABASECLEARLOGFILEGROUP1

C.ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP1

D.ALTERDATABASEDROPLOGFILEMEMBER’D：\REDO01.LOG’

点击查看答案

第3题

YourdatabaseissetinNOARCHIVELOGmodeandisbackedupeverynight.Thereare10redologgroupsonthedatabase，eachwiththreemembers，makingatotalof30redologfiles.Atlunchtimetheserverunexpectedlygetsshutdown.UponrestartingyounoticethatthedatafilebelongingtotheSYSTEMtablespacehasbecomecorrupted.Youalsonoticethattherehavebeen15logswitchesduringtheday.Whichsolutionshouldyouusetorecoverasmuchcommitteddataaspossible？（）

A.RestorethedatafilefortheSYSTEMtablespacethenopenthedatabase.

B.Restoreallredologsformlastnight‘sbackup,thenrestartthedatabase.

C.Performacompleterestoreofallfilesfromlastnight‘sbackup.Dataenteredintothedatabasetodaymustbereentered.

D.Mounttheinstance,taketheSYSTEMtablespaceoffline,openthedatabase,andthenrestorethedatafile,recoverit,andbringthetablespaceonline.

点击查看答案

第4题

YourdatabaseisinARCHIVELOGmode.Youhavetwoonlineredologgroupseachofwhichcontainsoneredomember.Whenyouattempttostartthedatabase，youreceivethefollowingerrors：ORA-00313：openfailedformembersofloggroup1ofthread1ORA-00312：onlinelog1thread1：’D：\REDO01.LOG’Youdiscoverthattheonlineredologfileofthecurrentredogroupiscorrupted.Whichstatementshouldyouusetoresolvethisissue？（）

A.SQL>ALTERDATABASEDROPLOGFILEGROUP1；

B.SQL>ALTERDATABASECLEARLOGFILEGROUP1；

C.SQL>ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP1；

D.SQL>ALTERDATABASEDROPLOGFILEMEMBER’D：\REDO01.LOG’；

点击查看答案

第5题

YourdatabaseisinNOARCHIVELOGmode.Thedatabasehasthreeonlineredologgroups，andeachgroupcontainsthreeonlineredologmembers.Theonlineredologmembersarestoredacrossthreeharddisks，E，F，andG，respectively.HarddiskGcrashedwhiletheLGWRbackgroundprocesswaswritingredoinformationtotheonlineredologfiles.Whateffectwillthiscrashhaveonthedatabase？（）

A.Thedatabasewilloperatenormallywithoutgeneratinganyredo.

B.Thedatabasewillhang，andyoumustshutdownandrestarttheinstance.

C.Thedatabasewillcrash，andyoumustrecoverthedatabasefromthepointoffailure.

D.ThedatabasewilloperatenormallyandwillgenerateminimalredoforthetablescreatedwiththeNOLOGGINGclause.

点击查看答案

第6题

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch? （）(Choose two.)

A. An entry is created in the alert log file and the database instance continues to function normally

B. The log switch hangs occur for transactions until free space is available in the flash recovery area

C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

点击查看答案

第7题

A.An entry is created in the alert log file and the database instance continues to function normally

B.The log switch hangs occur for transactions until free space is available in the flash recovery area

C.The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle

D.The database instance statusis implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

点击查看答案

第8题

DatafileDF1belongstotablespaceTS1.，andthedatabaseisinARCHIVELOGmode.Youdidanincompleterecoverinthefollowingsteps：1.TakedatafileDF1offline.2.CopyabackupcopyofDF1intothecurrentDF1location.3.ExecuteRECOVERDATAFILEUNTILTIMEsometimeinthepast.4.BringDF1online.5.ExecuteALTERDATABASEOPENRESETLOGS.Toguaranteethatthedatabaseisrecoverableinthefuture，whatistheleastamountofworkneeded？（）

A.Backupthedatafile.

B.BringtablespaceTS1online.

C.Copyredologstothebackupdirectory.

D.Makeacompletebackuprightafteropeningthedatabase.

点击查看答案

第9题

YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisinNOARCHIVELOGmode.Thedatabasehasbeenconfiguredwiththreeredologsgroups，andtherehavebeenfivelogswitches.Youlostonenon-system-criticaldatafilefromyourdatabase.Whichmethodwouldyouusetorecoverthedatafile？（）

A.Restoreallthedatafilesandopenthedatabase

B.Createthedatafileandperformtablespacerecovery

C.Noneedtorestoreanyfile，justrecoverthedatabase

D.Restoreonlythesystemdatafileandrecoverthedatabase

E.Restoreonlylostdatefileandperformtablespacerecovery

点击查看答案

第10题

Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）

A.V$LOG

B.V$LOGFILE

C.DBA_LOG_GROUPS

D.V$LOG_HISTORY

点击查看答案