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 :)

No comments:

Post a Comment