Solved

Windows 2008 Server backup with Oracle running?

Posted on 2010-11-09
10
809 Views
Last Modified: 2012-05-10
I have been searching for an answer to this question today, but with no luck.

Is it possible to use Windows 2008 Server image backup on a server with an oracle instance running?
That is, will the oracle instance be correctly backed up, or will it be messed up?
Anyone with experience on this issue?

One of my customers are upgrading to 2008 server and plans to use the 2008 server built-in backup solution that I have come to understand is a bit...bad.
His technician says that the 2008 server backup always want to make an image backup of the C volume.

I'm an Oracle DBA and know that Oracle files have to have identical timestamps for them to be valid, so an image backup solution that does not take a snapshot of the disk is of no use.

I consider this backup solution to be no good for an oracle installation, but the customer does not want to use any other backup solution...

regards
Alexander
0
Comment
Question by:Alexander_Moan
10 Comments
 
LVL 1

Expert Comment

by:kiggga
ID: 34093176
the image backup takes an image of the whole server but as you know, oracle needs to be in a consistent state.

i would recommend using the image backups to restore the server, but for oracle, you should probably do exports to a file and rely on that for a restore.  I guess you can use the image level backup to restore the exported oracle db file that was backed up.

in any case, you can easily perform a few tests to make sure this solution works and be able to perform restores.  

let me know how it goes.
0
 
LVL 3

Expert Comment

by:nlandas
ID: 34093226
About Acronis True Image Echo purports to do that. Create backup images of a live server running Oracle or MS SQL, Exchange, etc.
0
 
LVL 3

Accepted Solution

by:
nlandas earned 30 total points
ID: 34093237
I've used it with Exchange and Acronis is a great company. I trust them to tell the truth, I'd contact them directly for details on Oracle support.

http://www.acronis.co.kr/pr/2007/09/pr09-10-virtual-data-protection.html
0
 
LVL 8

Expert Comment

by:PaperTiger
ID: 34093518
I assume you mean image backup tool utilizing VSS. Yes, it works great. I personally use Acronis to backup both my Exchange and Oracle servers running on Windows 2008. I have also done a number of restores to test the image and data integrity. I rebuilt my systems including DC, Exchange, Oracle, ERP app with those images many times already.

On a separate note, for Oracle, you need more than one method of protection. Depends on your customer's application, I'd also suggest to incorporate RMAN or Oracle import/export, and if necessary, Double Take.



0
 
LVL 1

Expert Comment

by:kiggga
ID: 34093566
it sounds like the customer does not want to use any other backup solution and if they cannot be persuaded, sometimes you just have to make them happy.  my solution did not involve purchasing any other software.

there are plenty of backup solutions that they can use if you would like suggestions.  especially if the server is a virtual machine; even though oracle doesnt support VMware.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 34093950
I would do backups of Oracle through Oracle then allow the customer to use the Windows 2008 Server backup utility which isn't that good of a backup solution. You can then restore the Oracle database from backup and use the translog to restore any transactions from the last backup this will work without issues.
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 20 total points
ID: 34094164
If you can shut down the Oracle instance prior to taking the backup using the Windows tool, then that would be a decent solution.

Otherwise, you could still use Windows backup to create an image of the OS drive, then combine it with a full database backup using RMAN. It would still leave you with a need to create the image of the Oracle installation folders - which you might need to do separately.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34095371
Someone mentioned VSS.  Here's the Oracle link to using it if it is available to you:
http://download.oracle.com/docs/cd/B28359_01/win.111/b32010/vss.htm
0
 
LVL 34

Expert Comment

by:johnsone
ID: 34096044
What is the intended purpose of the image copy?

I would not suggest this as a backup solution, but if you wanted to make a copy it should be fine.

Is the database in archive log mode?

If not, then you don't have many options.

If it is, this is what I would suggest, without having to use other products.

ALTER DATABASE BEGIN BACKUP;
image copy
ALTER DATABASE END BACKUP;
ALTER SYSTEM SWITCH LOGFILE;

Once the logs are done being written to disk copy the archive directory again (there will be new files and you will need them to bring the database up on the other side).  After you copy the archive logs, you should be able to do cancel based recovery on the other side and then cancel the recovery after you apply the last log you have.
0
 

Author Closing Comment

by:Alexander_Moan
ID: 34128610
Question was weather or not an image copy using Windows 2008 server backup would function with an Oracle DB. Alernative pointed out, but really not answered.
0

Featured Post

Want to promote your upcoming event?

Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Account Lockouts 25 151
Bash Script to Analyze Oracle Schemas 11 84
Windows 7 won't join domain 4 42
ORA-00972: identifier is too long from Unix but not from Windows in SQLPLUS 17 47
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now