Difference between revisions of "Template:SQWareProduction sqwora RmanClone.ksh presentation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
 
(One intermediate revision by the same user not shown)
(No difference)

Latest revision as of 21:29, 16 June 2014


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