Category: Oracle

  • MySQL Backup Script in Perl for Linux

    This backup script requires Perl to be installed. The default version that comes with your Linux distribution will probably work fine. Check whether you have perl packages installed with the command rpm -qa | grep perl This script is capable of creating MySQL backup files, compressing the backups, deleting old backups and sending an email…

  • MySQL Backup Script in Perl for Windows

    This backup script requires Perl to be installed. Any recent Strawberry Perl version will work fine. It is capable of creating MySQL backups, compressing the backups, deleting old backups and sending an email when encountering an error. Edit it to supply your MySQL credentials and adjust the parameters to your requirements. Schedule it to run…

  • Automating Oracle RMAN backups

    Script Language: Korn Shell This RMAN backup script can be used to schedule full, incremental level 0 or incremental level 1 backups. I recommend running the INC0 backup on Wednesday evenings and INC1 on the other 6 days of the week in the oracle user’s crontab. It can update your recovery catalog with the latest…