Template:SQWareProduction sqwora RmanClone.ksh presentation

From Wiki_dbSQWare
Revision as of 17:46, 5 April 2014 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search


Makes RMAN clone
Script is fully automatic:

  • Check space (you have to customize this function)
  • Retrieve choosed backup that can be:


- LastFull => retrieve the last full backup
- LastInc => retrieve the last incremental backup
- MaxTime => retrieve the last backup
- <tag> => retrieve this backup tag (part of file name)

  • Unregister from RMAN catalog
  • Save old password
  • Destroy old database
  • Run cloning


The script can also:

  • ignore disk warning (stop by default)
  • makes copy backup only
  • change of unix users target/source
  • choose parallel degree of backup copy
  • send email report of cloning
  • run shell script before Load
  • run shell script after Load


This script use configuration file $gvsqw_RootCfg/sqwora_Rman.cfg