ORA-00479: RVWR process terminated with error

 Problem:

When trying to enable flashback feature on a 19c DB I get this error:

 26-Jun-2023 16:03:25 SYS@fq> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-00479: RVWR process terminated with error

Analysis:

Current SQLPlus session settings can contribute in getting this error.

Solution:

Connect to SQLPlus using "nolog" option, where login.sql will not be effective, then enable the Flashback feature:

[oracle@fq ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 26 16:10:52 2023
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.

SQL> alter database flashback on;

Database altered.