Skip to main content

Script to backup Oracle database on tape and ftp server

I had a production Oracle database server which was configured to to backup the full export of database to a tape drive connected to the server. The vendor had configured it and it was working for some time. As it usually happens the server was working fine and we “thought” the backup was working fine. I recently checked the backup as part of the implementation of disaster recovery and found it not working for several months. Hence I wanted a script that is simple and takes backup in two different locations so that I am safe if any disaster happens. I Googled and found a lot of scripts from several guys especially Cyberciti.
I thank you guys for publishing the knowledge that you acquired for helping others. So I feel that I also should give back to the world what I acquired from you.
Below is the script that I have created from several websites. It is self explanatory, but please do tweak as per your needs. In case of any issues please do get in touch with me so that I can help you.
Assume that you will be having basic knowledge of Linux, Linux scripts, Oracle etc. I don’t in not compressing and complicating the backup which in future while restoring may cause decompressing issues. Moreover my database was more than 7.5GB.

================================Script=====================================
#!/bin/bash
######
######Script for full export backup of DB to Tape and FTP
######Created by Anil Kumar
######

########Variable declaration#######
USERNAME="ftpusername"
PASSWORD="ftppassword"
SERVER="ip.add.re.ss"
FOLDER="/path/to/tempworkingfolder"
export ORACLE_SID=oraclesid
export ORACLE_HOME=/path/to/oracle/home
export CURR_DATE=`/bin/date +%d%m%y_%H%M%S`
PATH=$PATH:$ORACLE_HOME/bin;export PATH

########Oracle Export#######
exp dbauser/dbsuserpass file=/path/to/tempworkingfolder/finename_${CURR_DATE}_department.dmp log=/path/to/tempworkingfolder/filename_${CURR_DATE}_department.log compress=y statistics=none grants=y full=y

########Status of the tape########
mt -f /dev/st0 status > /path/to/tempworkingfolder/tapestatus_${CURR_DATE}_department.log

########Rewinding the tape########
mt -f /dev/st0 rewind
cd $FOLDER

########Copying files to the tape########
tar -cpf /dev/st0 *.*

########List of files on tape to make sure that the backup works fine########
tar -tvf /dev/st0 > /path/to/tempworkingfolder/backup_${CURR_DATE}_department.log

########Eject the tape, this will indirectly make sure the script worked and may be backup worked########
mt -f /dev/st0 eject

#########FTP Upload#########
cd $FOLDER
ftp -n -i $SERVER <<EOF
user $USERNAME $PASSWORD
mput *
quit
EOF

#########Deleting files in tempworking forlder other than script#########
rm -rf filename* *.log

================================Script=====================================

Comments

Popular posts from this blog

How to Configure Samba to Share a Folder with Two Users on Ubuntu (with Read/Write and Read-Only Permissions)

Samba is a file sharing software that allows you to share files between Linux and Windows computers. It is a popular choice for home users and businesses alike. In this article, we will show you how to configure Samba to share a folder with two users, one with read/write permissions and one with only read permissions, on Ubuntu. Prerequisites Before you begin, you will need the following: A Linux computer running Ubuntu Two user accounts A shared folder Steps Install Samba. sudo apt install samba Create the shared folder. sudo mkdir /shared Configure Samba's global options. Open the Samba configuration file /etc/samba/smb.conf in a text editor. Add the following lines to the [global] section: security = user passdb backend = tdbsam This will set the security mode to user , which means that users will be authenticated using their local Linux accounts. The passdb backend option specifies the database that Samba will use to store user passwords. In this case, we are using the tdbsa

GM Diet for the second time

I have yesterday started following GM diet for the second time. First was last month almost in the mid. I lost 2kgs. If you want to follow the diet scheme please find the details below. This is an extract of 'weight loss diet' circulated by many companies and banks among its employees in USA & India. This has proved to be the very effective program for weight loss. Hope this will be of much use to all those who are conscious of their weight and health. WEIGHT LOSS DIET for 7 days (Tested by corporates) This program was developed in conjunction with the grant from the US Department of Agriculture and the Food and Drug Administration. It was field tested at the Johns Hopkins Research Centre and was approved for distribution by the Board of Directors of General Motors Corporation at a general meeting on August 15, 1995. This Program is designed for a target weight loss of 5 - 6 Kgs per week. But it all depened on your body structure and the way you follow it. It will also impr

Create Great looking diagrams - Gliffy.com

I was looking for an online diagram creating tool. Came across Gliffy.com where I could create actually great looking diagrams without much of learning curve. The tool is 1. Very easy to use 2. Has drag and drop of elements to your diagram 3. Collaboration (which I have not tested). 4. Works from anywhere on a browser with Internet connection (I used it in Google Chrome on Linux Mint 10) When you click on the "Try it now" a new screen will open as below. You can either create a blank page to create a diagram from scratch or select from a bunch of samples and work on them to create one for your requirement. There are options to export the diagrams you created to SVG, JPEG, PNG and XML format once you register for free on the website. Once you register you can save the diagrams that you created in the site itself and retrieve it at a later time by logging into the website. I made three diagrams and it was real easy and simple. The site has two kind of pa