making LOG_ARCHIVE_DEST_1 become null again
I was fixing this database that I have to go through another ssh that also contains a database. (so ssh to a db server, and from there ssh to another db server).
I might have type exit one extra time. So I logged to the wrong db with sqlplus / as sysdba and from null I have done this :
------------This is original value ----
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
----------------------------
Then I did this:
alter system set LOG_ARCHIVE_DEST_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST"