All releases of DBAHelper


Release Notes: There are many little enhancements to the RMAN framework's create_standby and restore_full commands. Several small fixes have been applied to the restore_full and restore_ctl commands.


Release Notes: The "restore_ctl" command was added to rman.sh to restore a lost controlfile. Some minor fixes were made. The menu was split up. The "rmanw" script was added. In ExportOracleDB, bzip2 compression no longer ingores the --dryrun parameter.


Release Notes: The RMAN Framework has a complete interactive mode (including menus). create_standby now also handles SPFile and updates the primary instance (i.e. completely processes all required steps). There is a new command "switchover" to do a switchover between the primary and standby database.


Release Notes: The RMAN Framework was almost completely reworked, including a more friendly GUI if you have 'dialog' installed. create_standby now also handles creation of init.ora files and updates tnsnames.ora on demand. There is more error checking and some small fixes.


Release Notes: Changes in this version include a new "move_fra" command (to move the recovery area to a new location), an "--all" option for the "backup_daily" command (to support hosts with multiple databases more easily), and enhancements to the "create_standby" command (copying backups to a standby host using SCP, checking database status, and optionally starting up databases).


Release Notes: This release adds scripts to run the SQL Tuning advisor on a given statement and retrieve the results, and to list up all undo space used by current transactions. It adds index analysis to analobj.sh, and adds the create_standby command to the RMAN framework


Release Notes: Some fixes for the RMAN scripts. A script for Full Database Export has been added.


Release Notes: Huge enhancements were made to the rman.sh script.


Release Notes: Some fixes to the Generate_createDB.sh. An RMAN framework has been added to simplify RMAN usage (requires 10g with Recovery Area enabled and properly sized to hold the backups).


Release Notes: This release adds some restructuring/cleanup and extends idxrebuild_all and tabreorg to adjust storage parameters.