Replication VBR deleted the data

Replicate essentially "replicates" the object (as is) from source to target. If source object has no data, and you trigger replicate, the target object will also reflect that.
 

@veerkumar said:
and it should not delete any data at any cost.

There are many usecases in the database world where a table's data get deleted for various valid reasons. You would want your DR environment to also reflect these changes as is, else your DR environment will not be an accurate representation of your Primary.
 
My suggestion is not to trigger a replicate from 'Primary -> DR' when the DR has the most accurate representation of your data. You should rather trigger replicate from 'DR -> Primary' instead.
 
I could also imagine you using the objectRestoreMode=coexist parameter to ensure that data does not get overwritten and then if your tables are partitioned, use swap partition to instantaneously swap the accurate data into the primary's table.
 
Also, it's good to know that VBR uses rsync internally for replicate and copycluster activities.
Others may chime in here for any other ideas.

Thank you for response.
Is there any change in configuration that we can do ? such that it does not "replicate" the object, rather than just insert the new data of primary to destination ?

If this is only for specific tables, you can use EXPORT to VERTICA
1) identify the epoch of your backup:
$ vbr.py --task listbackup --config-file backup.ini**
backup backup_type epoch .....
bck_snapshot_20200722_092104 full 196 .....
bck_snapshot_20200722_085950 full 193 ......
2) export only the row higher than the backup epoch
vsql> EXPORT TO VERTICA AS SELECT * FROM my_table WHERE epoch > 196;