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