|
|
rman.sh create_standby: checking whether ORACLE_HOME is set and update of tnsnames succeeds |
|
rman.sh create_standby: init.ora adaptions: case insensitive search |
|
rman.sh create_standby: create and xfer passwordfile, displaying output on FORCE LOGGING |
|
rman.sh create_standby: more detailed output if creation of standby controlfile fails |
|
rman.sh create_standby: call to backup procedure failed (file extension missing) |
|
rman.sh: Logfile naming was incorrect in interactive mode |
|
rman.sh restore_full: added check of listener and database state before the restore starts; making sure the database can be mounted; warn user if it is completely open |
|
rman.sh restore_full/restore_ctl: The scripts have not been aware that really *everything* except the backup could be lost (e.g. unrecoverable disk crash). Should work fine now (hopefully) |
v0.2.6 (25.02.2008) | |
---|
|
|
rman.sh: new command "restore_ctl" to restore a lost controlfile either from a multiplexed copy (if available) or from backup (not yet completely tested) |
|
rman.sh: split up menu (got to large) |
|
rman.sh: some minor fixes (mainly concerning "DryRun" debug output) |
|
rman.sh: added "rmanw" script which will be installed into your path (plus an adapted rmanrc to /etc) to be able to call it from anywhere |
|
ExportOracleDB: bzip2 compression was ignoring the --dryrun parameter |
v0.2.5 (18.02.2008) | |
---|
|
|
rman.sh: create_standby now first checks whether SPFILE is used and (if so) offers to first create PFILE from this to proceed with. |
|
rman.sh: create_standby now also updates the primary database at the end of the process (to feed the standby etc.) |
|
rman.sh: new command "switchover" to perform the switchover between primary and standby database |
|
rman.sh: now comes with a menu when called w/o parameters (interactive mode) |
|
rman.sh: some more code reorganization |
v0.2.4 (10.02.2008) | |
---|
|
|
completely restructured the RMAN framework for a better UI handling. This uses the "dialog" tool if available (package "dialog" with most Linux distros), falling back to plain shell if not available (or configured otherwise) |
|
rman.rc: default settings for UI (USEDIALOG) and timeout of dialog boxes |
|
rman.sh: new parameters --[no]dialog to override settings for "dialog" usage |
|
rman.sh: backup_daily now checks the recovery window set by the corresponding rman*.conf file |
|
rman.sh: create_standby now also creates the init.ora files and transfers the copy to the standby |
|
rman.sh: config check (RMAN DB config) is no longer run on each call regardless of parameters - but only if jobs are called using that information |
|
rman.sh: cleanup_obsolete now also obeys the --all option |
|
rman.sh: Now we first make sure the rman and sqlplus utilities are found in the path before executing anything (to avoid stupid errors) |
|
rman.sh: Added disclaimer (only shown on first execution of rman.sh) |
|
rman.sh: create_standby now also can create the tnsnames.ora entry on both, the primary and standby host, plus mentions the optional entry for the listener.ora |
v0.2.3 (05.02.2008) | |
---|
|
|
rman.sh: added the move_fra command to move the recovery area to a new location |
|
rman.sh: create_standby now also copies backup files to new standby machine on demand (using scp), checks DB status and optionally starts up the database(s) |
|
rman.sh: added the --all option to the backup_daily command (for hosts with multiple databases) |
v0.2.2 (16.01.2008) | |
---|
|
|
added the sqltune script (for Oracle 10g) |
|
added script to list up undo records used by current processes |
|
rman.sh: Added the create_standby command |
|
analobj.sh: Added listing of index rebuild candidates |
|
globalconf: Now you can specify an output directory |
|
analobj.sh: Added more accurate listing for index rebuild candidates (when run with analyze - the other one runs without analyze, e.g. using the "--noanalyze" command line option) |
v0.2.1 (21.10.2007) | |
---|
|
|
fixed configuration issue with backup_daily (UNTIL TIME parameter was missing) |
|
force_clean was incorrect |
|
added script for full database export (with default options and optional compress) |
v0.2.0 (23.08.2007) | |
---|
|
|
rman.sh: added recover command |
|
rman.sh: colors now only used when TERM variable set (avoid errors w/ cron) |
|
rman.sh: added block_recover command |
|
rman.sh: added commands cleanup_expired and cleanup_obsolete |
|
rman.sh: added command force_cleanup. Use this with care. It's main intention is to work around a couple of Oracle bugs (see Metalink notes 4348860.1, 314217.1, 315098.1, 305812.1, 289653.1 as well as bugs 5073511 and 5106952). In short: RMAN doesn't care about the archived logs directly stored into the FRA (flash recovery area), and also forgets to purge cumulative backups (leaving them orphaned w/o any parent to apply them on) - with the final result that the FRA size will be exceeded, further backups fail due to this, and the database comes to a stand-still since redo logs cannot be archived anymore. If you don't have this problem, you don't need this command. |
|
rman.sh: added --yestoall option to allow unattended runs. Use this with care and only if you know what you are doing ;) |
|
added documentation for the rman.sh script |
|
rman.sh: outsourced config to rmanrc |
|
rman.sh: added cmd line options '-q' and '--dryrun' |
|
rman.sh: made TempTS settings configurable |
v0.1.8 (17.07.2007) | |
---|
|
|
Generate_createdb.sh: fixed duplicate execution of CREATE USER statements |
|
Generate_createdb.sh: fixed execution order: Don't change password for SYSTEM and then try to connect with the old password later |
|
Generate_createdb.sh: for system managed tablespaces, last datafile was added twice - fixed. |
|
added RMAN scripts (no documentation yet - simply run rman.sh w/o args to find out more) |
v0.1.7 (24.02.2006) | |
---|
|
|
lazywaste.sh: some restructuring |
|
updated some help messages within the scripts |
|
added parameter --force to idxrebuild_all.sh, tabmove.sh and tabreorg.sh |
|
idxrebuild_all.sh, tabreorg.sh: Now (optionally) also adjusts size of initial/next extent (based on index size). Use parameter --noadjust to ommit. |
|
if the scripts have been run without the -s parameter, and the given SID did not resolve via ONAMES/TNSNAMES, connection failed. Fixed. |
v0.1.6 (11.01.2006) | |
---|
|
|
tabreorg.sh: Added parameter --nostats to force rebuild (e.g. if no stats have been collected, so we know nothing about chain count etc.) |
|
added lazywaste.sh to find out about wasted resources and lazy sessions |
|
Generate_createdb.sh: Now using the print wrapper (from OraRep) (fixes some broken output) |
v0.1.5 (27.10.2005) | |
---|
|
|
Generate_createdb.sh: Default Storage parameters for Tablespaces are now only generated for dictionary managed TS (causes errors on creating locally managed TS) |
|
Generate_createdb.sh: Temporary TS statement is now also created |
|
Generate_createdb.sh: Rollback Segments are no longer created (and "altered online") when database is in auto undo mode |
|
Generate_createdb.sh: added export of public synonyms and database links (not owned by SYS or SYSTEM). |
|
Generate_createdb.sh: Now also creating roles |
|
Generate_createdb.sh: CREATE USERS are now done with the correct password (using the undocumented "identified by values" feature) |
|
analobj.sh now supports additional parameter --noanalyze (affects tables only, and then directly gives reports about chained rows) |
|
Generate_createdb.sh: Moved bootstrapping stuff to end of first segment (since these Oracle scripts stop spooling the log file) |
v0.1.4 (14.07.2005) | |
---|
|
|
added the Generate_createdb.sh script to the package |
|
renamed idxrebuild.sh to idxrebuild_inv.sh (rebuilding all invalid indices) |
|
new idxrebuild_all: now rebuilding all indices from the smallest to the largest (in bytes), and executing ALTER TABLESPACE..COALESCE in between |
v0.1.3 (12.02.2004) | |
---|
|
|
added documentation in HTML format |
|
updated most script headers concerning the "Usage"/"Syntax" output |
|
idxrebuild: fixed problem with optional 2nd parameter |
v0.1.2 (06.02.2004) | |
---|
|
|
all: scripts crashed on objects with names using mixed case |
|
all: enhanced command line syntax |
|
analobj: LOGALL can now be overridden on cmdline |
|
added tabreorg.sh (automatically re-organize fragmented tables) |
v0.1.1 (26.01.2004) | |
---|
|
|
idxrebuild: the second parameter (tablespace name) now is optional. If not specified, all tablespaces (including SYSTEM!) are checked. |
|
idxrebuild: fixed condition for "STATUS" (now skipping 'N/A' as well, since rebuilding partitioned indices requires special treatment) |
|
all: moved remaining configuration options from analobj.sh to globalconf. So from now on "globalconf" should be the only file the user has to edit. |
|
analobj.sh now optionally outputs complete log (logging all ANALYZE statements as well) |
v0.1.0 (15.01.2004) | |
---|
|
|
initial version (first release) |
|
---|
|