Friday, October 4, 2013

Turn on controlfile autobackup on in oracle

Because during the database recovery process it is very important to have the recent copy of the control file, RMAN provide you with the ability to automatically backup this file whenever there is a change in your database. However by default this feature is off so you have to turn on manually.

  1. Start RMAN and connect to a target database and a recovery catalog (if used).
  2. Check the status : rman>  SHOW CONTROLFILE AUTOBACKUP;
  3. Turn it on:  rman> CONFIGURE CONTROLFILE AUTOBACKUP ON;
  4. Check the status again, this time it should be on.
  5. For more about RMAN configuration parameters, just type : rman > SHOW ALL;

No comments:

Post a Comment