Generating data backup and restore scripts (UNIX or Linux)
backupScriptGen.xmlscript located in the
<INSTALL_DIR>/bindirectory using the following command:
-f backupScriptGen.xml -DdbType=<database_type>
script generates sample backup and restore scripts in the
You can rename and customize the scripts to suit your business needs. For example, you can modify the script to add your custom configuration tables and modify the path where the data files are stored. These scripts depend on utilities provided by the database vendors.
accepts the following arguments:
||Determines what kind of script is generated.
If "windows" is selected, a .cmd file is created.
If "linux" or "unix" is selected, a .sh file is created.
If "all" is selected, both .cmd and .sh files are created.
||Determines for which databases the scripts will be generated.||
||Determines which entities to generate scripts for. Valid values are any TableType attribute defined for an entity.||
Note: The value
creates both backup and restore scripts for the selected operating
systems and databases.
export, import, or sqlplusutilities. You can modify and use the following scripts:
backup_<tabletype>_<dbtype>.sh, a backup script for the given table type and database vendor.
restore_<tabletype>_<dbtype>.sh, a restore script for the given table type and database vendor.
delete_<tabletype>_<dbtype>.sql, a SQL script to delete all data of a given table type, used as part of a restore script.