New features in Bundle 5.6
export_data.sh script: For exporting data has been completely re-coded to come with the following new features:
– Execution of the export will run in the background “nohup mode”.
– Ability to exclude multiple schemas and tables from Full Database Export mode.
– You can provide multiple schemas to export in the Schema Export mode.
– Ability to exclude multiple tables from Schema Export mode.
– You can export multiple tables in Table Export mode.
– Ability to COMPRESS the dump file on the fly for all LEGACY export modes.
[This eliminates the need of compressing the dump file after the export operation, the thing will save the disk space]
– Parallelism option section will pop-up to the user only if the database edition supports parallelism [i.e. Enterprise Edition]
– Both Data Pump and Legacy export will use FLASHBACK SCN to export the data in a consistent state which is beneficial in cases such as
replicating tables using Goldengate or Oracle Streams.
– By the end of the Export operation the user will receive an Email notification [optional].
Bug fixes applied on the following scripts:
rebuild_table.sh script: for rebuilding tables online.
configuration_baseline.sh script: For gathering the baseline info for OS & DB.
dbdailychk.sh script: for generating Health Check report on the DB.
To download the DBA Bundle latest version:
https://www.dropbox.com/s/k96rl0f4g39ukih/DBA_BUNDLE5.tar?dl=0
For more reading on what this bundle for and how to use it:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html