Say for example i use a sequence to insert a record into a table, on the target side replicat inserts the records into the table ( value from sequence is hard coded in the trail file ). Replicat on the target side doesn't use the Sequence while inserting the record in short i would say.
When i query seq.nextval i get 1 on the target side, how would this scenario helps when the application is flipped to the target side, wouldn't there by constraint violation when the sequence is queried again and which starts with 1 again. How is the sequence unique value is maintained in this scenario irrespective of whether we do a flip or not?
I tried googling multiple blogs but no help.
Please help me with this doubt.