Using dsrutil applyextent to Reconstitute a Test DB

Posted by Paul Koufalis on 11-Apr-2014 14:57

In the non-Replication world, we can take last night's backup, restore it then apply the AI files in order to reconstitute a copy of the production DB.

Can I do the same with an OE Replication target?  I.e. can I take last night's backup of the target then use dsrutil applyextent to roll forward to the present?  Then disable replication and be confident that the DB is an exact copy of PROD?

All Replies

Posted by Libor Laubacher on 12-Apr-2014 06:42

You can use dsrutil applyextent only when RPLA is in pre-transition. You can restore the last night's backup, disable replication and then roll forward.

Posted by Paul Koufalis on 12-Apr-2014 13:35

I tried to restore the backup from the target, doing a triggertransition and then an applyextent but it failed saying it was expecting sequence #0.  

Posted by Libor Laubacher on 13-Apr-2014 06:12

Paul, I am not 100% sure on what does "I tried to restore the backup from the target, doing a triggertransition" exactly entail - can you post / mail me the steps ?

Posted by Paul Koufalis on 14-Apr-2014 15:38

probkup online target target.bkp

prorest newdb target.bkp

dsrutil newdb -C triggertransition

dsrutil newdb -C applyextent

This thread is closed