Backup your database!!!

Yes, I appologize for writing this sentence ... "Backup your database!!!" ... it sounds a bit frumpy, such as something from the past. But still nowadays with those high-class super storage solutions a valid backup can become of vital importance. Especially before you start the upgrade process.

backup.jpg

RMAN (Oracle Recovery Manager) does a great job in backing up your database completely online. Have I said online? Yes!! Even though some Metalink notes still recommend to do an offline backup you shouldn't stop your 58 TB data warehouse database for 2 days to do a complete offline backup. Use RMAN for your backups - and since Oracle Database 10g RMAN is really simple to use.

For your upgrades a complete online backup of your database will be your life insurance. So this should be always the first task. But: Don't forget to do a test restore. In my 6 years doing mission critical support in Oracle I've seen too often empty backup tapes, broken tape robots etc.

tapesalat.jpg

And after the test restore has finished you should definitely do a full recovery and measure the time it'll take to have your database up and running. These timings are important for your service level agreements. Make also sure you'll be able to access your backups when you'll really need them e.g. in case of an emergency. In todays data centers backups got written often to so called Virtual Tape Drives, storage drives. But what if your restore job's priority is too low? A German insurance (yes, an insurance!!) discovered in the test phase (and yes, they did test a lot!!!) that it'll take 3 days to access their backups for restoration just because of the low priority of their jobs. Very clever if you've found this out before you started your upgrades.

Make sure you have a valid and complete online backup - and do at least once a test restore - and don't forget the recovery!!!

Comments:

True, true and once again true Recovery test is a must and there is one another thing related to recovery test - a recovery procedure which is in place and tested too. Recovery time is always a very stressful and if you have a proper procedure it is easier to manage it. regards, Marcin Przepiorowski

Posted by Marcin Przepiorowski on August 19, 2009 at 03:26 AM CEST #

HI, Here you have posted very nice information about the particular topic, I really like it. It was great to know about it. Anyways Thanks for sharing the valuable information.

Posted by ANSH@backpackers sydney on August 19, 2009 at 03:23 PM CEST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers