Enterprise Replication db recovery
Hi. I have a database that uses Enterprise Replication (at least it appears to
be ER as opposed to High Availability Replication) based upon the use of "cdr"
commmands and CDR* onconfig parms. It is a simple setup though. It is ONEWAY
with only a subset of tables being replicated. So there is the Primary server
and the replication server. Now for my infamous dumb question. I do have level
0 ontape backups for both the PRIMARY and the Secondary that were created
while the replication was turned off. So I should be able to recover the
primary and recplicator dbs by simply A) making sure replication is OFF and
then B) just restoring the Primary Level 0 to the primary instance and the
Replication Level 0 to the Replication Instance? Does this sound right? I have
not done this before. Thanks
And restoring your logical logs on both, yes.
Art
On Fri, Oct 3, 2008 at 9:09 AM, WILL LANDSTROM <willlandstrom@yahoo.com>wrote:
> Hi. I have a database that uses Enterprise Replication (at least it appears
> to
> be ER as opposed to High Availability Replication) based upon the use of
> "cdr"
> commmands and CDR* onconfig parms. It is a simple setup though. It is
> ONEWAY
> with only a subset of tables being replicated. So there is the Primary
> server
> and the replication server. Now for my infamous dumb question. I do have
> level
> 0 ontape backups for both the PRIMARY and the Secondary that were created
> while the replication was turned off. So I should be able to recover the
> primary and recplicator dbs by simply A) making sure replication is OFF and
> then B) just restoring the Primary Level 0 to the primary instance and the
> Replication Level 0 to the Replication Instance? Does this sound right? I
> have
> not done this before. Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
If you are restoring the primary backup to the primary instance or the
secondary backup to the secondary instance, then there should be no iss=
ues.
If you are restoring both, then there could be some issues unless the
backups were taken at the same time, or unless you restore the logical =
logs
to the current time as well.
-------------------------------------
Madison Pruet, STSM
IDS Replication Architect
=
"WILL LANDSTROM" =
<willlandstrom@ya =
hoo.com> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Enterprise Replication db recove=
ry
10/03/2008 08:09 [13574] =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi. I have a database that uses Enterprise Replication (at least it app=
ears
to
be ER as opposed to High Availability Replication) based upon the use o=
f
"cdr"
commmands and CDR* onconfig parms. It is a simple setup though. It is
ONEWAY
with only a subset of tables being replicated. So there is the Primary
server
and the replication server. Now for my infamous dumb question. I do hav=
e
level
0 ontape backups for both the PRIMARY and the Secondary that were creat=
ed
while the replication was turned off. So I should be able to recover th=
e
primary and recplicator dbs by simply A) making sure replication is OFF=
and
then B) just restoring the Primary Level 0 to the primary instance and =
the
Replication Level 0 to the Replication Instance? Does this sound right?=
I
have
not done this before. Thanks
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=