Schedule Database Backup Job on Linux

1. Make Backup Script Having following Task: 

                a. That will make File Name (unique - by taking current system time)  

                b. Then Export Database with Log having system generated File Name as Above

                c. Then Zip These DMP and LOG file with Password

                d. Remove DMP & LOG, to release Space.

                e. Move ZIP file to Remote Location (NAS Drive/Backup Directory having FTP Enabled)

------------------------------------------------------------------------------------------------------------------------------

#BackupScript.sh

. /home/oracle/scripts/setEnv.sh

filename=$( date +%d%m%Y_%H%M)

BACKUP_DIR="/u02/backup"

expdp user/pass@db_pdbp schemas=users directory=datapump dumpfile=$filename.dmp logfile=$filename.log

#tar -zcvpf $BACKUP_DIR/$filename.tar.gz $BACKUP_DIR/$filename.dmp $BACKUP_DIR/$filename.log

zip --password "ZIP_PASS" $BACKUP_DIR/$filename.zip $BACKUP_DIR/$filename.dmp $BACKUP_DIR/$filename.log

rm $BACKUP_DIR/$filename.dmp $BACKUP_DIR/$filename.log

cd $BACKUP_DIR

ftp -n NASDRIVE_IP/HOSTNAME << EOF

user USERNAME PASSWORD

cd Backups

put $filename.zip

EOF

-----------------------------------------------------------------------------------------------------------------------------

2. Schedule JOB

    a. Schedule BackupScript by using

    crontab -e

30 21 * * * sh /home/oracle/scripts/BackupScript.sh >> /home/oracle/scripts/Back                                                                                        upLogs/backup_06_30PM.log 2>&1

00 13  * * * sh /home/oracle/scripts/BackupScript.sh >> /home/oracle/scripts/Bac                                                                                        kupLogs/backup_12PM.log 2>&1

  b. Add Log of RUN JOB into Logs

30 18 * * * sh /home/oracle/scripts/BackupScript.sh >> /home/oracle/scripts/Back                                                                                        upLogs/backup_06_30PM.log 2>&1
00 12  * * * sh /home/oracle/scripts/BackupScript.sh >> /home/oracle/scripts/Bac                                                                                        kupLogs/backup_12PM.log 2>&1

Comments

Post a Comment

Popular posts from this blog

Addition of New Hard Drive in DellPower Edge R740xd

Since the prevailing system was configured with RAID 10, so it is necessary to Add new Hard Drives as Even i.e. you have to add hard drives (Physical) in even numbers means you have to add either 2 or 4 or 6 or 8 or 10 so on.  Once added, you have to reconfigure RAID by adding these hard drive , note if you does not select hard drive in even number, then it will not proceed.
Read more

How to Create Virutal Host in Xampp For Clonning of WordPress or OtherSite on Local Machine

Since Creating a Clone for the purpose of Testing or Development, we have to perform many different task like changing the host names especially in WordPress. Hence in this tutorial I will show how to skips old techniques of changing host URLs in the site. Instead of replacing the URL - Site/Host Address from the cloned environment, we will create our Local Machine as the Virtual Host i.e. it will behave as the same site as of production. So dont need to change the URL/Address from the enviroment. Following are the steps using Xampp  Step 1) C:\WINDOWS\system32\drivers\etc\ Open the "hosts" file : 127.0 . 0.1 localhost 127.0 . 0.1 test.com 127.0 . 0.1 example.com Step 2) xampp\apache\conf\extra\httpd-vhosts.conf <VirtualHost *: 80 > DocumentRoot C:/xampp/htdocs/test/ ServerName www.test.com </VirtualHost> <VirtualHost *: 80 > DocumentRoot C:/xampp/htdocs/example/ ServerName www.example.com </VirtualHost> ...
Read more