Search

Loading...
Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Wednesday, 11 April 2012

Point to be considered with RMAN Backup Scripts


  1. After Each and Every Backup must read Backup log file carefully.
  2. Put  “Set Echo ON” at the beginning of RMAN script then RMAN will reflect all command in log files.
  3. Use “Show all” Command in RMAN script, it will allow you to understand behaviors of RMAN Backup.
  4. Use the command to find the Total execution time of script in the RMAN backup script that will help you to manage the expected time of next backup.
  5. Do not overwrite the Backup log files. The log file is good alternative solution of information in case the Rman Catalog is not available. Use the command to generate log file sequence or some alternative solution.
  6. Do not use Crosscheck command with RMAN backup script. By using it wrong place in your backup script will make recovery impossible. Handle it manually as required for precaution. 
  7. Always Backup controlfile as the last step in your backup script. After that do not use Crosscheck or Obsolete command.
  8. Do not rely on one backup only. You should always have second option for potential recovery. Possibly keep one set of copy to another server.
  9. Use Connect Target with RMAN Backup script rather than passing it as an RMAN Executable Parameter.
  10. Use “resync catalog” command to synchronize the Catalog with the backup as a last step of the RMAN script.
  11. Do not rely on the RMAN stored configuration setting always put the configuration with the Backup script.
  12. Use “Report Need Backup” command to verify your backup up to the mark of recovery process.
  13. Use “Report unrecoverable” command with the backup script. This will indicate which database files need to be backed up to meet a configured or specified retention policy
Simple RMAN Backup Scripts:
Following script will describe how we can take full database backup using RMAN command line interface;
In first step you need to connect the rman with target database:

RMAN TARGET SYS/ORACLE@SADHAN.WORLD CATALOG CATALOG/CATALOG@RMAN

RMAN> run{
configure controlfile autobackup format for device type disk to 'd:/rmanbackup/%F';
configure controlfile autobackup on;
allocate channel d1 type disk;
backup tag FULL_DB format 'd:/rmanbackup/db_%t_%s.bk' (database);
release channel d1;
}
Note: Don't forget to create the backup directory which you have configured.

0 comments:

Post a Comment