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

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
 
Line 17: Line 17:
* choose parallel degree of backup copy
* choose parallel degree of backup copy
* send email report of cloning
* send email report of cloning
* run shell script before Load
* run shell script before load
* run shell script after Load
* run shell script after load
<br>This script use configuration file $gvsqw_RootCfg/sqwora_Rman.cfg
<br>This script use configuration file $gvsqw_RootCfg/sqwora_Rman.cfg

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