I tried to use DQL to set both my IS to active, by setting the is_standby flag to ‘0’, but instead encountered an error. The DQL was:
select r_object_id, index_name, ft_engine_id, is_standby from dm_fulltext_index
But I managed to do it by using API. Obtain the r_object_id from the DQL above. Using API:
- Command: dump,c,r_object_id
- Command: set,c,r_object_id,is_standby
- Data: F
- Command: save,c,r_object_id
Run the DQL again, both entries will have is_standby as ‘0’.