1 technique to be safe and not sorry as Oracle DBA

Your handy scripts are as important as your Oracle DBA profile. We do have lot of scripts, documents, white papers and so on for our reference which are very vital throughout the career. The first source to find answers for any issue or an activity in the environment is your catalog directory where you must have saved all the reference docs and if not, you might be searching for answers in search engines like google, Bing etc.

What if your directory is crashed or lost due to hardware or operating system issues?

Oops!!! You would feel that all your efforts are lost. I am sure, as a proactive Oracle DBA you might be taking your directory backups manually, but how frequent? For me even 1-day of data loss can be dangerous.

I had a similar bad experience after which I began following a method. I am elaborating here best possible solution, that has worked for me till now.

Lesson:

I had 2 years of Oracle DBA experience when I faced my first and final data loss. All my collection of scripts, tools, software’s, documents, white papers, Oracle certificates and so on was saved in a separate directory for quick and easy access – hope you must be doing the same. I didn’t even know that all the data I gathered so far was very precious and saving a copy is critical. On one bad day, Boom!!! my system hard disk crashed and data got permanently erased and cannot be recovered.

I was shocked to know that all my hard work is lost in a second. This instance has also taught me that our data backup is as important as the daily RMAN backups of Oracle Database 🙂. One thing is always clear since beginning of my career that I love these challenges and fun in life of Oracle DBA.

After good amount of research, me with existing backup team found very good free backup tools in the market.  Out of them, I have decided to use AceBackup freeware tool to schedule my data directory on my laptop. Till date, I am using the same tool.

Though my favorite tool which I will be further explaining is AceBackup, you can also find various other tools on internet. One such blog is  http://pcsupport.about.com/od/backup/tp/free-backup-software.htm

  • Always use your shared network drive to pick your data backup. There is no point in taking backup in the same hard disk as your data is in.

Schedule your backup:

  1.   Install any backup tool on your laptop/desktop, I used AceBackup tool as an example.
  2. o2

  3. Create a new backup project
  4. o3

     

  5.   Name your backup project and click on the location and edit to choose your path.
  6. o4

     

  7. Choose network resource from the drop down list and provide relevant network drive credentials,click ok and then next.
  8.  

    o5

  9. Use proprietary file format so that tool will perform incremental backups and also will be able to restore previous versions of your files.Just like your SVN.You may use encryption and compression.
  10. o6

     

  11.   You may define proper versioning and logging options for your requirement and then click Next.
  12.  

    o7

  13.   Click on Schedule and choose your appropriate timings of your data backup.
  14.  

    o8

  15.   Now redirect to your directory and right click on the panel above the backup project and select Add to backup.
  16. o9

     

     

  17.   Check the directory which you wanted to add to the current backup project called “Daily backups”.
  18. o10

     

     

  19.   It performs a quick backup of the directory you selected. Click on Finish.
  20. o11

     

     

  21.   You can now find this directory added to your “Daily backups” project in the panel.
  22. o12

     

     

Highlights:

  • Don’t let this happen to you, search for good backup tools and adopt them as soon as possible.
  • There are also better tools in the market, but I always prefer to use already existing tools instead of writing our own scripts to take backup of your files.
  • Do not schedule backups for huge data like software’s, Images and unnecessary documents. It might take lot of time and resources on your system
  • Finally, your data backup is as important as your profile and better be safe than sorry.

Leave your comments – I love to know your feedback.

 

Related Posts

About The Author

Add Comment