Projects / DBAHelper

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

Tags
Licenses
Operating Systems
Implementation
Translations

RSS 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 04:58

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.

  •  17 Feb 2008 17: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 13: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 03: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).

Screenshot

Project Spotlight

ISPMan

An ISP manager.

Screenshot

Project Spotlight

Sqrat

A C++ binding utility for the Squirrel language.