ORACLE ADR 不能直接执行repair failure，需要先执行advice failure，生成修复脚本

正确答案：D

一、模拟上题的错误：

１、删除4号文件

[html] view plain copy

1. [oracle@mydb~]$cd/u01/app/oracle/oradata/ocm/
2. [oracle@mydbocm]$rm-rfusers01.dbf

２、数据库宕机

[html] view plain copy

1. sys@OCM>shutdownabort;
2. ORACLEinstanceshutdown.

３、启动数据库报错，与上题报错一样

[html] view plain copy

1. sys@OCM>startup
2. ORACLEinstancestarted.
4. TotalSystemGlobalArea839282688bytes
5. FixedSize2233000bytes
6. VariableSize583011672bytes
7. DatabaseBuffers247463936bytes
8. RedoBuffers6574080bytes
9. Databasemounted.
10. ORA-01157:cannotidentify/lockdatafile4-seeDBWRtracefile
11. ORA-01110:datafile4:'/u01/app/oracle/oradata/ocm/users01.dbf'

４、如果试图在没有执行advise failure命令时使用repair failure命令，将出现如下错误：

[html] view plain copy

1. [oracle@mydb~]$rmantarget/
2. RMAN>repairfailure;
4. usingtargetdatabasecontrolfileinsteadofrecoverycatalog
5. RMAN-00571:===========================================================
6. RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============
7. RMAN-00571:===========================================================
8. RMAN-03002:failureofrepaircommandat09/01/201323:15:16
9. RMAN-06954:REPAIRcommandmustbeprecededbyADVISEcommandinsamesession

　　　主要原因是：在运行repairfailure之前，要先运行advise failure，让rman列出错误，并且生成修复脚本，之后运行repair failure修复错误。

一、正确的恢复的过程如下：

１、启动RMAN客户机，并使用前一节介绍的数据库修复命令来解决丢失数据问题，我们从list failure命令开始：

[html] view plain copy

1. RMAN>listfailure;
3. ListofDatabaseFailures
4. =========================
6. FailureIDPriorityStatusTimeDetectedSummary
7. -----------------------------------------------
8. 2002HIGHOPEN01-SEP-13Oneormorenon-systemdatafilesaremissing

２、advisefailure命令对记录在自动诊断信息库中的所有故障给出建议。默认时，此命令只列出具有critical或high优先级的那些故障。除了产生所有输入故障的摘要外，此命令还对每个故障提供一个建议修复选项。通常，advise failure命令同时给出自动和手动修复选项。在advisefailure命令输出结束时，RMAN生成一个脚本，列出建议的修复选项的细节。如果你想自己进行修复，可以直接使用这个脚本，或者对它进行修改。

　　

[html] view plain copy

1. RMAN>advisefailure;
3. ListofDatabaseFailures
4. =========================
6. FailureIDPriorityStatusTimeDetectedSummary
7. -----------------------------------------------
8. 2002HIGHOPEN01-SEP-13Oneormorenon-systemdatafilesaremissing
10. analyzingautomaticrepairoptions;thismaytakesometime
11. allocatedchannel:ORA_DISK_1
12. channelORA_DISK_1:SID=10devicetype=DISK
13. analyzingautomaticrepairoptionscomplete
15. MandatoryManualActions
16. ========================
17. nomanualactionsavailable
19. OptionalManualActions
20. =======================
21. 1.Iffile/u01/app/oracle/oradata/ocm/users01.dbfwasunintentionallyrenamedormoved,restoreit
23. AutomatedRepairOptions
24. ========================
25. OptionRepairDescription
26. ------------------------
27. 1Restoreandrecoverdatafile4
28. Strategy:Therepairincludescompletemediarecoverywithnodataloss
29. Repairscript:/u01/app/oracle/diag/rdbms/ocm/ocm/hm/reco_3275375759.hm

３、利用advise failure命令提供的建议，epair failure根据建议修复错误。

[html] view plain copy

1. RMAN>repairfailure;
3. Strategy:Therepairincludescompletemediarecoverywithnodataloss
4. Repairscript:/u01/app/oracle/diag/rdbms/ocm/ocm/hm/reco_3275375759.hm
6. contentsofrepairscript:
7. #restoreandrecoverdatafile
8. restoredatafile4;
9. recoverdatafile4;
10. sql'alterdatabasedatafile4online';
12. Doyoureallywanttoexecutetheaboverepair(enterYESorNO)?Y
13. executingrepairscript
15. Startingrestoreat01-SEP-13
16. usingchannelORA_DISK_1
18. channelORA_DISK_1:startingdatafilebackupsetrestore
19. channelORA_DISK_1:specifyingdatafile(s)torestorefrombackupset
20. channelORA_DISK_1:restoringdatafile00004to/u01/app/oracle/oradata/ocm/users01.dbf
21. channelORA_DISK_1:readingfrombackuppiece/u01/app/oracle/product/11.2.0/dbs/0uoiptgq_1_1
22. channelORA_DISK_1:piecehandle=/u01/app/oracle/product/11.2.0/dbs/0uoiptgq_1_1tag=TAG20130901T230250
23. channelORA_DISK_1:restoredbackuppiece1
24. channelORA_DISK_1:restorecomplete,elapsedtime:00:00:03
25. Finishedrestoreat01-SEP-13
27. Startingrecoverat01-SEP-13
28. usingchannelORA_DISK_1
30. startingmediarecovery
31. mediarecoverycomplete,elapsedtime:00:00:01
33. Finishedrecoverat01-SEP-13
35. sqlstatement:alterdatabasedatafile4online
36. repairfailurecomplete
38. Doyouwanttoopenthedatabase(enterYESorNO)?Y
39. databaseopened