ADSM-L

Re: [ADSM-L] TSM VE backup of Orcale Windows server

2013-07-17 12:27:06
Subject: Re: [ADSM-L] TSM VE backup of Orcale Windows server
From: "Ryder, Michael S" <michael_s.ryder AT ROCHE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 17 Jul 2013 12:24:45 -0400
Andy:

VE uses Microsoft VSS (Volume Shadow copy Service), which was not available
with Windows 2000.
Oracle VSS Writer is only available with Oracle 9i or later.

On Windows 2003 and newer, and Oracle 9i and alter, we have no trouble with
hot-backups of Oracle systems where we have the Oracle writer for VSS
installed.

I can't explain why your DB would get corrupt, but without VSS and
VSS-Writer for Oracle, there isn't any integration between Oracle and the
snapshot process.  That in itself might be enough to explain it.

On servers where we couldn't get VSS Writer for Oracle installed, we only
do cold-backups by using VMware tools to execute batch-commands to properly
shutdown and restart applications and their Oracle databases.

I think you will only be able to get away with cold-backups in your current
configuration.

Mike

Best regards,

Mike
RMD IT, x7942


On Wed, Jul 17, 2013 at 11:20 AM, Huebner, Andy <andy.huebner AT alcon DOT 
com>wrote:

> We ran our first backup of a Oracle server using TSM VE and the Oracle DB
> reported many errors and it caused the Oracle DB to become corrupt.  I
> believe Oracle crashed and it was later recovered.
>
> Has anyone had any issues backing up a live Oracle system with TSM VE?
>
> Oracle - v.Old
> Windows - 2000 (laugh it you want, but I bet you have some too)
> TSM agent 6.4.0.0
> TSM Server 6.2.3.100
>
> There is far more to the process and well thought out reasons, but this is
> the bit that is having an issue.
>
>
> Andy Huebner
>