login as: rsaadmin Using keyboard-interactive authentication. Password: <enter OS user password> Last login: Tue Jul 15 14:07:01 2023 from jumphost.vcloud.local RSA Authentication Manager Installation Directory: /opt/rsa/am rsaadmin@am87p:~> cd /opt/rsa/am/utils rsaadmin@am87p:/opt/rsa/am/utils> ./rsautil manage-secrets -a get com.rsa.db.dba.password Enter the OC admin user: <enter Operations Console administrative user name> Enter the OC admin password: <enter Operations Console administrative user password> com.rsa.db.dba.password: rSKD5bGguLGNL9uGvFWnJoxIcHJah2 rsaadmin@am87p:/opt/rsa/am/utils> /opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba Password for user rsa_dba: <enter the com.rsa.db.dba.password captured above> psql.bin (9.2.4) SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) Type "help" for help.
db=# SELECT * FROM rsa_rep.IMS_INSTANCE_NODE; id | instance_id | name | host | ip | product_patch | activation_time | last_updated_on ----------------------------------+----------------------------------+-----------+------------------------+---------------+---------------+-------------------------+------------ ------------- 6d779c4bea8b1f0a1ab26476086cfb4f | 075b5175ea8b1f0a08024e4d8ee9036e | replica87 | replica87.rsalocal.com | 10.31.139.234 | | 2015-09-21 08:19:30.972 | 2023-06-21 08:26:52.6 151e9003598b1f0a1a90a885b26a6634 | 091ca479598b1f0a080258079e9bd683 | primary87 | primary87.rsalocal.com | 10.31.139.89 | | 2015-09-18 12:04:40.3 | 2023-06-21 08:28:03.756 (2 rows)
Enter the following SQL statement to list the contents of the rsa_rep.IMS_INSTANCE table:
db=# SELECT * FROM RSA_REP.IMS_INSTANCE; id | cpu_count | description | is_primary | deployed_state ----------------------------------+-----------+--------------------------------+------------+---------------- 091ca479598b1f0a080258079e9bd683 | 1 | Initial primary instance. | t | 0899bb5ea8b109876fds4e10466ldcca | 1 | inserted by attachment process | f | active 075b5175ea8b1f0a08024e4d8ee9036e | 1 | inserted by attachment process | f | active (3 rows)
Note that the instance_id captured in step 4 is the id in step 5. Also note carefully which row has the listing for is_primary set to false and note the ID number for that instance.
IF YOU HAVE MORE THAN ONE REPLICA use the ID number for the replica that needs to be resynched that was captured in step 5 to update IMS_INSTANCE to change the deployed state of the replica.
db=# UPDATE RSA_REP.IMS_INSTANCE SET deployed_state = 'out_of_sync' WHERE is_primary='FALSE' AND id = 'instance_id from step 5';
For example,
db=# UPDATE RSA_REP.IMS_INSTANCE SET deployed_state = 'out_of_sync' WHERE is_primary='FALSE' AND id = '075b5175ea8b1f0a08024e4d8ee9036e'; UPDATE 1
db=# UPDATE RSA_REP.IMS_INSTANCE SET deployed_state = 'out_of_sync' WHERE is_primary='FALSE'; UPDATE 1
db=# SELECT * FROM RSA_REP.IMS_INSTANCE; id | cpu_count | description | is_primary | deployed_state ----------------------------------+-----------+--------------------------------+------------+---------------- 091ca479598b1f0a080258079e9bd683 | 1 | Initial primary instance. | t | 075b5175ea8b1f0a08024e4d8ee9036e | 1 | inserted by attachment process | f | out_of_sync (2 rows)