ORA-00257
ORA-00257: archiver error. Connect internal only, until freed.
Verify the usage of the archive log destination using the following SQL command:
SQL> ARCHIVE LOG LIST;
This command will display the current status and location of the archive logs.
If the archive log destination is full, free up disk space by deleting or moving old archive logs to another location.
$ rm /path_to_archive_logs/*.arc
Modify the archive log destination to a location with sufficient disk space:
SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/new_path_to_archive_logs' SCOPE=SPFILE; SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP;
This change will take effect after restarting the database.
Force manual archiving to free up space:
SQL> ALTER SYSTEM ARCHIVE LOG ALL;
This command will manually archive all redo logs, which can help in clearing space in the redo log destination.
You attempt to connect to the database and receive the ORA-00257 error. Checking the archive log destination shows it is full:
SQL> ARCHIVE LOG LIST; Database log mode Archive Mode Automatic archival Enabled Archive destination /opt/oracle/archivelogs Oldest online log sequence 105 Next log sequence to archive 106 Current log sequence 106
Solution: Delete old archive logs from the /opt/oracle/archivelogs directory.
The current archive log destination is nearly full, and you want to change it to a new location:
SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/new_archivelogs' SCOPE=SPFILE; SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP;
This will move the archive log destination to /new_archivelogs, ensuring sufficient space.
ORA-00257: Archiver Error