Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts

Thursday, November 14, 2013

How to list and fix failure in RMAN

Step to list any failure in Oracle RMAN

          $ rman target /
          RMAN > LIST FAILURE;

Step to fix RMAN failure

          $ rman target /
          RMAN > ADVISE FAILURE;
          RMAN > REPAIR FAILURE PREVIEW;
          RMAN > REPAIR FAILURE;
         

After fix failure not close automatically, then we need to close this failure manually
          RMAN > change failure <failure_id> closed;


Enjoy :)