Template:SQWareProduction sqwora RmanClone.ksh presentation

From Wiki_dbSQWare
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

Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_RmanClone.ksh_presentation&oldid=5385"