• 搜标题
  • 搜题干
  • 搜选项
0 / 200字
单项选择题

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

A.Asaresult，yourdatabasehascrashed.Youhavetriedtorestartthedatabaseandcleartheonlineredologfiles，butwhenyoutrytoopenthedatabaseyougetthefollowingerror.
B.
C.
D.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3
E.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3
F.logORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.log
G.Issuetherecoverdatabaseredologscommand.
H.IssuetheStartupMountcommandtomountthedatabase.
I.Restorethelastfulldatabasebackup.
J.Performapoint-in-timerecovery，applyingallarchivedredologsthatareavailable.
K.Restoreallarchivedredologsgeneratedduringandafterthelastfulldatabasebackup.
L.Openthedatabaseusingthealterdatabaseopenresetlogscommand.
题目列表

你可能感兴趣的试题

问答题

在Excel2003中，记录单命令可以进行的操作是( )。

A.插入记录
B.还原记录
C.编辑记录
D.删除记录
E.查看记录
单项选择题

Youhavelostdatafile4fromyourdatabase.Whichistypicallythefastestwaytorestoreyourdatabase？（）

A.Restoreandrecoverthedatafile.
B.Restoreandrecoverthetablespace.
C.Restoreandrecoverthedatabase.
D.Restoreandrecoverthecontrolfile.
E.Restoreandrecovertheparameterfile.
微信扫码免费搜题