The database alert log for the Oracle database, which is by default located in /u01/app/oracle/diag/rdbms/avdb/AVDB/trace/alert_AVDB.log may grow to an unreasonable size which makes it hard to edit/handle it. It may also contain data from many years ago, which is unnecessary for database management and irrelevant for uploads to RSA Support.
Archive the current database alert log and create a fresh new one.
The easiest way to accomplish this is to simply move/rename the file and let Oracle create a new one.
You can do this associated with an Oracle restart, or while the database is running.
Upon Oracle startup, a new file named alert_AVDB.log will be created in the same location.
If you rename the file while the database is running, and do not want to wait until the database writes to it to ensure everything is ok, you can issue the following command which forces a write to the alert log and will recreate the file at this time:
sqlplus / as sysdba
SQL> alter system switch logfile
All operations described here require access to the Linux oracle account.
After running the alter command you will have these files:
From this point the database will write to the new alert log.
These instructions are mainly intended for RSA Identity Governance & Lifecycle Hardware Appliance customers and customers with Software Appliances with an RSA supplied database. Customers with remote databases are encouraged to contact their DBAs for this task.