Veritas-bu

[Veritas-bu] VERITAS Database Edition for Oracle on Solaris

2002-10-04 09:47:36
Subject: [Veritas-bu] VERITAS Database Edition for Oracle on Solaris
From: Mark.Parsisson AT NCFE DOT com (Mark Parsisson)
Date: Fri, 4 Oct 2002 09:47:36 -0400
I forgot to note, we are also using the Verital Oracle NB client so using
RMAN we go straight to tape, not RMAN -> disk -> tape. Just wanted to
clarify.

Mark

-----Original Message-----
From: Mark Parsisson [mailto:Mark.Parsisson AT ncfe DOT com]
Sent: Friday, October 04, 2002 9:24 AM
To: 'Peter DrakeUnderkoffler'; Rien, Julie L. [C]
Cc: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: RE: [Veritas-bu] VERITAS Database Edition for Oracle on Solaris


We have had spotty success with RMAN. The setup in the beginning does take
some extra effort. However, once that is done, backups hum along well. The
problems we have had are the times when we need to restore an Oracle DB via
RMAN. One outage took us around 36 hours to get RMAN to actually do the
*first* step of the restore. Each time we started a restore request it would
work for several hours then promptly die spitting out a few errors. Our
DBA's worked with Veritas support during the entire restore. Eventually the
restore worked but not due to any particular config or process change. Just
happened that one time it actually worked. The total restoration time start
to finish was around 72 hours. Lucky for us it was over a weekend so only
one day of production was lost really.

My point is, RMAN is a good way to do hot backups of DB's. Just be aware
that it may take a long time to recover a DB is the planets aren't aligned
just right. Others may have better mileage, I'm only speaking from our
experiences here.

Mark

-----Original Message-----
From: Peter DrakeUnderkoffler [mailto:pcd AT xinupro DOT com]
Sent: Friday, October 04, 2002 7:32 AM
To: Rien, Julie L. [C]
Cc: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: Re: [Veritas-bu] VERITAS Database Edition for Oracle on Solaris


"Rien, Julie L. [C]" wrote:
> 
> To all:
> 
> System details:
> SUN Enterprise 5500
> 2 A1000 Arrays
> 1 L1000 Tape Library
> 
> Software:
> Solaris 8
> Oracle 8i
> VERITAS Volume Manager
> VERITAS NetBackUP
> 
> We currently allow 4.5 hours of down time a night to do daily exports and
> backups through oracle export and netbackup respectively.  Our window of
> down time is shrinking beyond a point that utilizing incremental backup
will
> not shorten our backup time enough.
> 
> I have been researching solutions to this and have come up with two
options
> to allow for 24hr by 7day uptime but allow for solid backups.
> 1. SNAPSHOT -- will not work because of the oracle db (this is a db
> server...its only purpose)
> 2. VERITAS Database Edition for Oracle on Solaris
> 
> I was hoping that this group may have some success stories with VERITAS
> Database Edition for Oracle on Solaris OR suggestions on other solutions
you
> have used.
> 
> I am interested in hearing your restoring experiences with either of these
> options also.
> 
> Thank you in advance for your help.
> 
> Julie
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Hot backups with NetBackup via RMAN have always worded well.  It is
a little extra work to setup in the beginning, but it is well worth it.
I've set it up several times on various sized databases.  Of course
I needed a DBA to deal with the RCAT database and all the other Oracle
specific things.


Thanks
Peter
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This message contains information intended only for the use of the
addressee(s) named above, and may contain information that is privileged and
confidential.  If you are not the intended recipient of this message, or the
employee or agent responsible for delivering it to the intended recipient,
you are hereby notified that any dissemination or copying of this message is
strictly prohibited.  If you have received this message in error, please
immediately notify us by replying by e-mail and destroy the original
message.  Thank you.
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This message contains information intended only for the use of the
addressee(s) named above, and may contain information that is privileged and
confidential.  If you are not the intended recipient of this message, or the
employee or agent responsible for delivering it to the intended recipient,
you are hereby notified that any dissemination or copying of this message is
strictly prohibited.  If you have received this message in error, please
immediately notify us by replying by e-mail and destroy the original
message.  Thank you.