YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning,whilequeryingtheuser1.employeestable,youreceivethefollowingerrormessage:
01578:ORACLEdatablockcorrupted(file5,block51)ORA-01110:datafile5:
’/u01/app/oracle/oradata/orcl/example01.dbf’
Youneedtorectifythecorruptionwhileensuringthefollowing:Thedatafileshouldremainonline.
Themeantimetorecover(MTTR)shouldbeminimal.
Youarenotusingabackupcontrolfile,andallthearchivedlogsareaccessible.
Whichoptionwouldyouchoose?()
时间:2024-05-06 17:29:43
相似题目