restoring a source database

[sdutta]

Good Afternoon,

We are in the processing of creating a sandbox for our main replication so that we can test replication related procedures utilizing two of our test databases. I've been reading the OpenEdge guide for the replication.

On page 82/234 [http://documentation.progress.com/output/OpenEdge102b/pdfs/ffr/ffr.pdf ] it stats that you can disable replication first then restore your source database, delete db-name.repl.recovery file and the restore process will automatically enable the replication.

My question is
1) Do I need to do anything else to the target or will the source start to replicate to the target automatically?

2) There is a line in the documentation that states "The target database must be resourced after the restore, disable, and enable has been performed". What does the document mean by "resourced"?

I'm a beginning DBA so I apologize in advance if I've asked any novel questions. Thanks.

 

[Casper]

You say:

delete db-name.repl.recovery file and the restore process will automatically enable the replication​

In the doc it says that if the restored database has replication enabled, it still wil be enabled after restore. thats different.​

There is a line in the documentation that states "The target database must be resourced after the restore, disable, and enable has been performed". What does the document mean by "resourced"?​

The line before states:​

Replication cannot be restarted for this database until OpenEdge Replication is disabled​

and then re-enabled.

So in this case you need te disable replication for the source database, reenable it and make a new target database from this database.​

The reason for this is stated in the last paragraph:​

Once a database is enabled for OpenEdge Replication, information about the state of
OpenEdge Replication is kept in the database itself. This information is not restored when
the database is restored. The only way to recover this information is to re-enable the​

database for OpenEdge Replication.

HTH,​

Casper.​