Shell script to rebuild an entire database.
The script creates a tar files with the export output and the necessary loads command.
Example:
Our environment:
db name: DAN_PROD
Run the rebuiddb.ksh script on the source server like:
./rebuiddb.ksh dan_prod
A tar file will be created:
file name has the following syntax: <db name>._rebuild.tar.gz
In this case the file name will be: dan_prod_rebuild.tar.gz
Move this files to the target server, uncompress it and run the following script like:
script name syntax: <db name>.rebuld_onTarget.ksh
In this case the script name will be: dan_prod.rebuld_onTarget.ksh
Run it as follow:
./dan_prod.rebuld_onTarget.ksh dan_prod
Note: When migrating a database to case insensitive ( for example, version v8 or v9.1 to v9.5 ) letters with accent will use the double of length. This script increase 30% of length to all char, varchar and character.
Script links:
Shell script to rebuild an entire database - part 1.
Shell script to rebuild an entire database - part 2.