Wednesday, January 20, 2021

New Features Added to Import Data Script

 I've added the following features to the import_data.sh script:

If the Flashback Database feature is turned ON the script will offer the user to turn it OFF during the import, then after the completion of the import the script will automatically turn it back ON:

But please be aware that when Flashback Database get turned OFF, all the flashback logs will be deleted, which means you will not be able to flashback the database to a point in time prior to turning it OFF.

Also, the script will delay the drop of the importer user --which get created during the import process for the purpose of running the import job.

To download the script:
https://www.dropbox.com/s/5qmfaeos9w4tj63/import_data.sh?dl=0

To get more details on how to use the script please follow the main article:
https://dba-tips.blogspot.com/2020/12/import-shell-script-for-importing-data.html

Wednesday, January 13, 2021

Configuration Baseline Report is Now Available in HTML

 Few years back I've shared script that collect a snapshot of OS & DB configurations and settings to help  DBAs rollback/compare system setting at a given point in time.

What is new here? The script is now can collect the Database configuration baseline report in HTML format.

Download link:
https://www.dropbox.com/s/vf527mb46l2iivp/configuration_baseline.sh?dl=0

Please note that the OS configuration baseline report remains in text format.

Read more: Script features and how to use:
http://dba-tips.blogspot.com/2016/12/configuration-baseline-script-for-linux.html

GitHub version:


Tuesday, January 5, 2021

DBA Bundle 6.1

 The new release of DBA Bundle for Jan is now available:

 The 6th version of DBA Bundle is now available:

https://www.dropbox.com/s/llj0n4qr4puyinp/DBA_BUNDLE6.tar?dl=0

After opening the link click on the Down Arrow on the right side:




The new features include:

A new script is now available for importing data using impdp, it will help you have easy and safe experience with impdp tool along with other options to help you speed up the data import:
http://dba-tips.blogspot.com/2020/12/import-shell-script-for-importing-data.html

Minor updates and bug fixes added to the following scripts:

dbdailychk.sh ... Generates daily health check report for databases

aliases_DBA_BUNDLE.sh ... Setup aliases for the bundle's scripts in the environment

export_data.sh ... export data

To learn about the DBA Bundle and how to use it:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html