Archive log files stored in $ORACLE_HOME/dbs

2019-09-04 15_54_24-Clipboard

Checking archive log list

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST,
Oldest online log sequence 84
Next log sequence to archive 85
Current log sequence 85

SQL>

SQL> sho parameter log_archive_dest_1
NAME                                 TYPE        VALUE
———————————— ———– ——————————
log_archive_dest_1                   string      location=USE_DB_RECOVERY_FILE_
DEST, valid_for=(ALL_LOGFILES,
ALL_ROLES)

the problem is the , after USE_DB_RECOVERY_FILE_DEST,  <——

Remove the ,
Alter system set log_archive_dest_1 = ‘location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES, ALL_ROLES)’ sid=’*’;

This should fix the issue