Error:
ORA-00257: archiver error. Connect internal only, until freed.
Reason:
File recovery area is above specified size.
Action:
Without increasing DB_RECOVERY_FILE_DEST_SIZE :
1. Check whether the database is in archive log mode and automatic archiving is enabled.
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 29 Next log sequence to archive 31 Current log sequence 31
2. If archive destination is defined by USE_DB_RECOVERY_FILE_DEST, find the archive destination by:
SQL> show parameter db_recovery_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string C:oracleproduct10.2.0/flash_recovery_area db_recovery_file_dest_size big integer 2G
Check what the value for db_recovery_file_dest_size.
3. Find the space used in flash recovery area by using following SQL:
col ROUND(SPACE_LIMIT/1048576) heading “Space Allocated (MB)” format 999999 col round(space_used/1048576) heading “Space Used (MB)” format 99999 col name format a40 select name, round(space_limit/1048576) As space_limit,round(space_used/1048576) As space_used from v$RECOVERY_FILE_DEST;
4. If SPACE_USED is equal to SPACE_LIMIT of db_recovery_file_dest, move the archive logs to different destination.
5. Archive all the log files
SQL> alter system archive log all;
6. Just switch the logs to verify
SQL> alter system switch logfile;
7. DB_RECOVERY_FILE_DEST_SIZE is to delete (archive log) files from DB_RECOVERY_FILE_DEST if you are sure you have backups and the archived logs are no longer necessary.
$rman target / RMAN>delete archivelog until time ‘SYSDATE-1’; or, RMAN>delete archivelog all;
By increasing DB_RECOVERY_FILE_DEST_SIZE :
SQL> show parameter db_recovery_file_dest;
NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string C:oracleproduct10.2.0/flash_recovery_area
db_recovery_file_dest_size big integer 2G
Check what the value for db_recovery_file_dest_size.
Increase the Flash Recovery Area
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=’10G’ SCOPE=BOTH;
Sytem Altered.
http://itnewscast.com/database/error-ora-00257-archiver-error-connect-internal-only-until-freed
http://oraworks.wordpress.com/2011/08/08/ora-00257-archiver-error-connect-internal-only-until-freed/