After restoring the AVDB Oracle database for RSA Identity Governance & Lifecycle, the following messages are observed in the alert log (alert_AVDB.log).
Mon Oct 15 15:54:05 2018
RFS: Assigned to RFS process (PID:7236)
RFS: Database mount ID mismatch [0xa8f4332e:0xa9ec7096] (2834576174:2850844822)
RFS: Destination database ID mismatch [0xa81982fa:0xa296f354] (2820244218:2727801684)
RFS: Not using real application clusters
The typical location for the AVDB database is /u01/app/oracle/diag/rdbms/avdb/AVDB/trace/.
The typical filename is alert_AVDB.LOG.
However, this may be different if RSA Identity Governance & Lifecycle is in remote database configuration (aka DB_REMOTE).
Important Note: Oracle Data Guard is not part of the RSA Identity Governance & Lifecycle out-of-the-box installation package or product.
The AVDB database has been left in Oracle Data Guard mode and the primary/standby configuration no longer applies.
Oracle Data Guard mode is implemented by the following Oracle database parameters.
log_archive_dest_n, where one of these parameters are still pointing to the original primary database.
Examples of these database settings are as follows;
Do not remove the similar setting from the AVDB database, as it is needed for normal operation.
Remove the Oracle Data Guard settings from the AVDB Oracle database, and re-start the database.
Connect to the database as SYSDBA: # sqlplus / as SYSDBA
Remove the Oracle Data Guard settings;
SQL> alter system reset log_archive_config scope=spfile sid='*';
SQL> alter system reset fal_server scope=spfile sid='*';
SQL> alter system reset fal_client scope=spfile sid='*';
SQL> alter system reset log_archive_dest_n scope=spfile sid='*';
Where, n is the setting number that has the "service=..." entry
Exit from SQL*Plus, and restart the AVDB Oracle database.
# acm stopdb
# acm startdb
NOTE: If the entry does not exist, then Oracle will return the following error: