Kbase P52938: Fathom Replication: After-Image to roll forward up to ENDTIME or ENDTRANS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
After-Image from Source roll-forward on backup of Target database
GOAL:
Off-line backup on Target and After-Image on Source for ROLL FORWARD ENDTIME or ROLL FORWARD ENDTRANS
FACT(s) (Environment):
Fathom High Availability Replication 2.0A
FIX:
There is no way to use the After_Image extents from the Source database on the Target database yet. You would need either to make database backup on Source or have After-Image on Target.
Being able to rollforward AI extents from Source database on an off-line backup of Target database would still require a proquiet to be issued on Source; the time where all activity stops on Source will not be longer with a probkup on-line. The reading of all DB blocks by probkup online should not be a huge overhead, it is extra I/O's but it is not affecting the buffer pool.
As per our analysis the best method for beefing able to recover the database till a certain time or a certain transaction is the following:
. run regularly probkup on-line on Source database (within source.bkup for example)
. keep copy of After-Image extents
The restore is done with the following method:
prorest newcopy source.bkup
proutil newcopy -C disablesitereplication source
rfutil newcopy -C roll forward -a <extent> [ endtime <time>]