Tuesday, 11 December 2012

ORA-00257: archiver error

ORA-00257: archiver error

ORA-16014: log 4 sequence# 4614 not archived, no available destinations
ORA-00312: online log 4 thread 1: '/u01/oracle/oracle/oradata//redo04a.log'

This is usually because the archive log drive has become full and needs to be cleared down. The first step is to make some more space on the archivelog drive. You can find out where you are archiving your logs to by looking at the init.ora or spfile and checking the log_archive_dest_n parameter. Normally log_archive_dest_1 is the local archiving location.

If you are having trouble actually logging on to the database to check the value for the archiving location just open up the SPFILE or INIT.ora file in a notepad and search for the parameter in there.

You also have the option to change the location of where the archivelogs are being written to, using the following command:

ALTER SYSTEM SET log_archive_dest_1 = 'LOCATION=/Disk2/oraclelogs/ArchLogs' SCOPE=both;
If you are having issues logging onto the DB check out the strategy below which should get you logged on if your normal way of logging on doesn't work.

Once you have cleared down some space for new archive logs, you will need to log on to the database and clear the archive logs. You may not be able to log in to the database as you normally would. That being the case, this time you need log on using the following sequence:

set oracle_sid = TESTDB
sqlplus /nolog
conn sys/ as sysdba
archive log all;
Once complete, you should see the archive logs being created on the archive log drive and operation of your database should continue as normal, hopefully... If not, check the alert log and see what other errors you have.

It should be noted that if you need to keep the archive logs and they haven't been backed up you should perhaps move them somewhere temporarily until you can be sure they have been backed up before you delete them.

Alternate solution

Connect with rman and delete some old archivelogs,

[oracle@ip*********** ~]$ rman target /

Recovery Manager: Release - Production on Tue Dec 11 15:30:37 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL1 (DBID=!!!!!!!!!!!!)

RMAN> delete noprompt archivelog all completed before 'sysdate-7';


No comments:

Post a Comment