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)
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

Revision as of 18:46, 5 April 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