Audit attribute client_identifier from the USERENV context is not being stored with flashback data archive records after restarting database instance. Oracle standard edition version 19.17

1 Answer 1


It seems that after instance is restarted, the instance will forget value of flashback data archive context level if it was set to a value different than TYPICAL. In my case, before restarting instance, context level was set in ALL. So, after instance restart, I had to set value of context level to ALL again using the following command


for more info about context level, see https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_FLASHBACK_ARCHIVE.html#GUID-B89C99AE-EE5A-4EEC-B66E-3CA1F6D90877

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.