ORA-00257: archiver error. connect as sysdba only until resolved

1) Arch filesytem is 100% full.

check filesystem, if archive FS is 100% used then use RMAN to backup and delete the archive logs.

rman target /

RMAN> list archivelog all; 

RMAN> crosscheck archivelog all;

RMAN> backup archivelog all delete input; --> Backup and delete from disk

2) Filesystem is fine but still issue then issue could be due to FRA

 Find where archive logs are being created.

sqlplus / as sysdba

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     43

Next log sequence to archive   45

Current log sequence           45

SQL>

SQL> sho parameter db_recovery

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      /u01/app/archives

db_recovery_file_dest_size           big integer 9546M

db_recovery_file_dest_size  is 9gb

$cd /u01/app/archives

df -h .

Filesystem                        Size    Used     Avail    Use%    Mounted on

/dev/mapper/orad-arc        100G    30g       71g        30%    /u01/app/archives

Space is available on Filesystem. check v$flash_recovery_area_usage.

from below, archive logs are using 92.67% of FRA.  we need to increase the FRA.

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE

----------------------- ------------------ -------------------------

NUMBER_OF_FILES     CON_ID

--------------- ----------

CONTROL FILE                           .19                         0

              1          0

REDO LOG                              6.29                         0

              3          0

ARCHIVED LOG                         92.67                         0

             38          0

FILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE

----------------------- ------------------ -------------------------

NUMBER_OF_FILES     CON_ID

--------------- ----------

BACKUP PIECE                           .38                         0

              2          0

IMAGE COPY                               0                         0

              0          0

FLASHBACK LOG                            0                         0

              0          0

FILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE

----------------------- ------------------ -------------------------

NUMBER_OF_FILES     CON_ID

--------------- ----------

FOREIGN ARCHIVED LOG                     0                         0

              0          0

AUXILIARY DATAFILE COPY                  0                         0

              0          0

8 rows selected.

SQL> alter system set db_recovery_file_dest_size=20g scope=both;

System altered.

SQL> sho parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest_size           big integer 20G

SQL>

SQL> alter system switch logfile;

System altered.

SQL>/

System altered.