Networker

Re: [Networker] Point In Time Recover with BCV using Legato 7.3.2

2007-04-28 08:27:09
Subject: Re: [Networker] Point In Time Recover with BCV using Legato 7.3.2
From: "Faidherbe, Thierry" <Thierry.Faidherbe AT HP DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Sat, 28 Apr 2007 12:24:23 -0000
Fully correct.

Depending of where the corruption is or to recover from
partially lost of data, you can also mount the BCVs on an 
alternate node from same OS type. Then, using Oracle Archived 
Redo logs, apply forward archive logs until point in time 
before the corruption or data lost occurs.
Then, you can export what you need (table for sample)
using standard Oracle export feature and then to reimport
them on prod db.

This, for sample, avoid you to recover the entire Prod DB.

Don't keep always sync'ed BCV, you will lose all DRP feature.
Another way, is using 2 pairs of BCV and syncing them on a
round-robin base. Doing so, you always have Day-1 BCVs.
In case of prob, resync Day-1 BCV to prod and apply Oracle
archived redologs.

Another good practice is to avoid archived redologs to stay
on same system the DB resides. So, a good way is,
at regular interval or as soon as a new archive log has been
created, to move/stage it to another system. Having lot of db,
you can create a structure like \<oracle server>\<oracle SID>
on a dedicated host and stage the archives from different hosts. 
Then, backup that structure and, if backup is ok, clean the structure.
Worked at such a setup, and worked like a charm.
Major advantage is if archives are not flushed yet to tape,
you can directly recover BCVs and reapply them without performing 
a tape recover !

HTH

TH
 



Kind regards - Bien cordialement - Vriendelijke groeten,

Thierry FAIDHERBE

HP Services - Storage Division
Tru64 Unix and Legato Enterprise Backup Solutions Consultant
                                  
 *********       *********   HEWLETT - PACKARD
 *******    h      *******   1 Rue de l'aeronef/Luchtschipstraat
 ******    h        ******   1140 Bruxelles/Brussel/Brussels
 *****    hhhh  pppp *****  
 *****   h  h  p  p  *****   100/102 Blv de la Woluwe/Woluwedal
 *****  h  h  pppp   *****   1200 Bruxelles/Brussel/Brussels
 ******      p      ******   BELGIUM
 *******    p      *******                             
 *********       *********   Phone :    +32 (0)2  / 729.85.42  
                             Mobile :   +32 (0)498/  94.60.85
                             Fax :      +32 (0)2  / 729.88.30  
     I  N  V  E  N  T        Email/MSN : thierry.faidherbe(at)hp.com
                             Internet  : http://www.hp.com/
Enterprise number 0402.220.594 - RPM/RPR Brussels
 
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Stuart Whitby
Sent: vendredi 27 avril 2007 14:37
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Point In Time Recover with BCV using Legato
7.3.2

If this is for an Oracle system, then as long as you're backing up your
archive logs, you have the opportunity to use these to do a point in
time recovery.  You'd mount the BCV, then roll forward using the archive
logs until the point where the corruption occurs.
 
Otherwise, your main way of avoiding this is to run ZFS.  I believe that
this will give you the point in time recovery capability that you're
after from the file side.
 
Cheers,
 
Stuart.

________________________________

From: EMC NetWorker discussion on behalf of Diwakar Kumar
Sent: Thu 26/04/2007 13:36
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Point In Time Recover with BCV using Legato 7.3.2



Dear All,

I need you guy's suggestion and help.

I am finding the way to point in time recovery oracle data using Legato
7.3.2. We have two set of BCV of production system. As we know that BCV
will
synch with production on time interval. We can't keep always sync. Even
if
we synch always any data corruption happen then it will get copied to
BCV
also. My concern is supposed if BCV was sync at 3:00AM every day and
disaster happen at 4 AM. How to avoid to loose 1 hour data? Is there any
way
to do with RMAN? Please help me. We are using VCS 5.0 where we can't use
snapshot which is not supported with 7.3.2. Please advise me.



Thanks & Regards,

Diwakar Kumar

"A vision without a task is a dream; A task without a vision is
drudgery;
But a vision, with a task, is the hope of the world."




To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER



To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER