
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).
License: GNU General Public License (GPL)
Changes:
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.
More...