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).
|Implementation||PL/SQL Unix Shell|
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).