Projects / DBAHelper


DBAHelper is a collection of scripts to ease the daily maintenance work of Oracle database administrators. Examples are moving objects between tablespaces, analyzing schemata, and rebuilding invalid indices. Also included is a little framework to simplify the use of RMAN (this framework depends on the use of Oracle 10g with the Recovery Area enabled and properly sized, so all backups go there).

Operating Systems

Recent releases

  •  11 Jul 2008 17:34

    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.

    •  25 Feb 2008 12:58

      Release Notes: The "restore_ctl" command was added to 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.

      •  18 Feb 2008 01:17

        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.

        •  10 Feb 2008 21:59

          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.

          •  05 Feb 2008 11:05

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


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.