{"id":26,"date":"2012-02-22T11:03:00","date_gmt":"2012-02-22T10:03:00","guid":{"rendered":"https:\/\/oracledba.fr\/?p=26"},"modified":"2023-09-12T10:42:02","modified_gmt":"2023-09-12T08:42:02","slug":"le-dra-data-recovery-advisor","status":"publish","type":"post","link":"https:\/\/oracledba.fr\/?p=26","title":{"rendered":"DRA: Data Recovery Advisor"},"content":{"rendered":"
\n

\nThe data recovery advisor makes it possible to detect corruption or loss of data, determines the actions to be carried out and suggests the actions to be taken to repair the database.<\/span><\/span><\/div>\n
This can saves you lots of hours if you are not sure what you can do.
\n<\/span><\/span><\/p>\n
<\/div>\n
LIST FAILURE<\/span><\/span><\/div>\n
The LIST FAILURE command allows you to display problems that are in OPEN status with different levels of criticality.<\/div>\n
\u00a0<\/span><\/span><\/div>\n
RMAN> LIST FAILURE;<\/span><\/div>\n

\nList of Database Failures
\n=========================<\/span><\/div>\n

\nFailure ID Priority Status \u00a0 \u00a0Time Detected Summary
\n———- ——– ——— ————- ——-
\n48 \u00a0 \u00a0 \u00a0 \u00a0 HIGH \u00a0 \u00a0 OPEN \u00a0 \u00a0 \u00a022-FEB-12 \u00a0 \u00a0 One or more non-system datafiles are missing<\/span><\/p>\n
<\/div>\n

ADVISE FAILURE<\/span><\/span><\/p>\n

ADVISE FAILURE as its name indicates, allows you to give advice for repairing the problems listed by the LIST FAILURE command. If possible it will create a script to fix the problem.
\nIf another failure appears after the list failure, this will not be included in the advice given by the ADVISE FAILURE command. You must redo a FAILURE LIST for this to be taken into account.
\n
\n<\/span><\/span>
\nRMAN> advise failure;<\/span><\/span>
\n
\n<\/span><\/span>
\nList of Database Failures<\/span><\/span>
\n=========================<\/span><\/span>
\n
\n<\/span><\/span>
\nFailure ID Priority Status \u00a0 \u00a0Time Detected Summary<\/span><\/span>
\n———- ——– ——— ————- ——-<\/span><\/span>
\n48 \u00a0 \u00a0 \u00a0 \u00a0 HIGH \u00a0 \u00a0 OPEN \u00a0 \u00a0 \u00a022-FEB-12 \u00a0 \u00a0 One or more non-system datafiles are missing<\/span><\/span>
\n
\n<\/span><\/span>
\nanalyzing automatic repair options; this may take some time<\/span><\/span>
\nusing channel ORA_DISK_1<\/span><\/span>
\nanalyzing automatic repair options complete<\/span><\/span>
\n
\n<\/span><\/span>
\nMandatory Manual Actions<\/span><\/span>
\n========================<\/span><\/span>
\nno manual actions available<\/span><\/span>
\n
\n<\/span><\/span>
\nOptional Manual Actions<\/span><\/span>
\n=======================<\/span><\/span>
\n1. If file \/oracle\/oradata\/orcl\/datafile\/o1_mf_users_7n6xprq9_.dbf was unintentionally renamed or moved, restore it<\/span><\/span>
\n
\n<\/span><\/span>
\nAutomated Repair Options<\/span><\/span>
\n========================<\/span><\/span>
\nOption Repair Description<\/span><\/span>
\n—— ——————<\/span><\/span>
\n1 Restore and recover datafile 4<\/span><\/span>
\nStrategy: The repair includes complete media recovery with no data loss<\/span><\/span>
\nRepair script: \/oracle\/diag\/rdbms\/orcl\/ORCL\/hm\/reco_1941492637.hm<\/span><\/span><\/p>\n

REPAIR FAILURE<\/b><\/span><\/span>
\n
\n<\/b><\/span><\/span><\/div>\n
REPAIR FAILURE runs the script generated by the ADVISE FAILURE command. The preview option allows you to see the contents of the file without applying it.<\/div>\n
\u00a0<\/span><\/div>\n

RMAN> REPAIR FAILURE PREVIEW;<\/span><\/span>
\n
\n<\/span><\/span>
\nStrategy: The repair includes complete media recovery with no data loss<\/span><\/span>
\nRepair script: \/oracle\/diag\/rdbms\/orcl\/ORCL\/hm\/reco_1941492637.hm<\/span><\/span>
\n
\n<\/span><\/span>
\ncontents of repair script:<\/span><\/span>
\n# restore and recover datafile<\/span><\/span>
\nsql ‘alter database datafile 4 offline’;<\/span><\/span>
\nrestore datafile 4;<\/span><\/span>
\nrecover datafile 4;<\/span><\/span>
\nsql ‘alter database datafile 4 online’;<\/span><\/span>
\n
\n<\/span><\/span>
\nBy default, the REPAIR FAILURE command requests confirmation to apply the corrections. This can be overridden with the NOPROMPT option.
\n
\n<\/span><\/span>
\nRMAN> REPAIR FAILURE NOPROMPT;<\/span><\/span>
\n
\n<\/span><\/span>
\nStrategy: The repair includes complete media recovery with no data loss<\/span><\/span>
\nRepair script: \/oracle\/diag\/rdbms\/orcl\/orcl\/hm\/reco_1941492637.hm<\/span><\/span>
\n
\n<\/span><\/span>
\ncontents of repair script:<\/span><\/span>
\n# restore and recover datafile<\/span><\/span>
\nsql ‘alter database datafile 4 offline’;<\/span><\/span>
\nrestore datafile 4;<\/span><\/span>
\nrecover datafile 4;<\/span><\/span>
\nsql ‘alter database datafile 4 online’;<\/span><\/span>
\nexecuting repair script<\/span><\/span>
\n
\n<\/span><\/span>
\nsql statement: alter database datafile 4 offline<\/span><\/span>
\n
\n<\/span><\/span>
\nStarting restore at 22-FEB-12<\/span><\/span>
\nusing channel ORA_DISK_1<\/span><\/span>
\n
\n<\/span><\/span>
\nchannel ORA_DISK_1: starting datafile backup set restore<\/span><\/span>
\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set<\/span><\/span>
\nchannel ORA_DISK_1: restoring datafile 00004 to \/oracle\/oradata\/ORCL\/datafile\/o1_mf_users_7n6xprq9_.dbf<\/span><\/span>
\nchannel ORA_DISK_1: reading from backup piece \/oracle\/flash_recovery_area\/backups\/ORCL\/ORCL_db_gqn3uqh2.rmanbck<\/span><\/span>
\nchannel ORA_DISK_1: piece handle=\/oracle\/flash_recovery_area\/backups\/ORCL\/ORCL_db_gqn3uqh2.rmanbck tag=TAG20120222T095753<\/span><\/span>
\nchannel ORA_DISK_1: restored backup piece 1<\/span><\/span>
\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01<\/span><\/span>
\nFinished restore at 22-FEB-12<\/span><\/span>
\n
\n<\/span><\/span>
\nStarting recover at 22-FEB-12<\/span><\/span>
\nusing channel ORA_DISK_1<\/span><\/span>
\n
\n<\/span><\/span>
\nstarting media recovery<\/span><\/span>
\nmedia recovery complete, elapsed time: 00:00:00<\/span><\/span>
\nFinished recover at 22-FEB-12<\/span><\/span>
\nsql statement: alter database datafile 4 online<\/span><\/span>
\nrepair failure complete<\/span><\/span><\/p>\n

<\/div>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

The data recovery advisor makes it possible to detect corruption or loss of data, determines the actions to be carried out and suggests the actions to be taken to repair the database. This can saves you lots of hours if you are not sure what you can do. LIST FAILURE The LIST FAILURE command allows … <\/p>\n

Continue reading “DRA: Data Recovery Advisor”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,12,11],"tags":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-data-recovery-advisor","category-dra","category-rman"],"_links":{"self":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=26"}],"version-history":[{"count":2,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":291,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/26\/revisions\/291"}],"wp:attachment":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}