An ERROR occurred while connecting to the database prompting the archive to solve (1) problem [SQL] SQL> conn hr/hr error: ORA-00257: archiver ERROR. connectinternal only, until freed. warning: You are no longer connected toORACLE. (2) After the problem analysis is performed on oracle 10 Gb, If flashback is enabled, the background archive program (ARCn) will automatically create a copy of each archived redo log in the Flash recovery area, the flashback area has a size limit: [SQL] SQL> show parameter recovery NAME TYPE VALUE ------------------------------------------------------------------------ db_recovery_fil E_dest string/opt/oracle/flash_recovery_area db_recovery_file_dest_size big integer 3882 M recovery_parallelism integer 0 when the falshback space is full, the connection to the database fails. (3) Problem Solving l delete some archived logs l add space limit for falshback [SQL] SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE = 20g; System altered. (4) monitor flashbackl to view information about the flash recovery zone [SQL] SQL> select * from v $ recovery_file_dest; NAME SPACE_LIMITSPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES =---------- certificate ---------------/opt/oracle/flash_recovery_area 2.1475E + 10 4190778368 0 95 l view flash area usage [SQL] SQL> select * from v $ snapshot; FILE_TYPE define NUMBER_OF_FILES -------------------- convert --------------- control file 0 0 0 redo log 0 0 0 0 archived log 19.51 0 95 backup piece 0 0 0 image copy 0 0 0 flashback log 0 0 0 0 FOREIGN ARCHIVED 0 0 7 rows selected.