=====Overview=====
During a switchover you might need to drop and re-create sequences. As such, here is a simple script to do so:

===Run on OLD primary===
<sxh bash>
select 'drop sequence ibp.'||object_name||'; create sequence ibp.'||object_name||' increment by 1 start with '||ibp.getsequencevalue(object_name)||' MAXVALUE 999999999999999999 MINVALUE 1;'
from dba_objects where owner = 'schema_name' and object_type = 'SEQUENCE';
</sxh>


The output you should run on the NEW primary.