Ora-00257

I got an error message when I connect to oracle 8i, which is about ora-00257. I took a look at the error message. It said the archiver desitination is full. I checked the disk storage. Yes, it was full and then I freed them by deleting the old archiving logs. When I see there are enough space for archiving,I connected to the database. Unfortunately, the same error came up again. Should I delete all the archiving logs and make the archiving destination available 100% or I have to restart the database?
If I try to restart the database, there are a archiving process suspending.

Thanks in advance.

Do 'alter system archive log current'

sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;

if archive log destination is full the above command it sets/starts archiving to secondary destination i.e which we are specifying so that you wonot get any error

Hi,
Even after u free space in archive destination, oracle will still not be able to open the failed destination.

use the below command

ALTER SYSTEM ARCHIVE LOG START;

and Arch process will start archiving the redologs to the same destination

regards
anandkl

Quote:

---

sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;

---

You need the REOPEN at the end, or else it won't start achiving. (and it's log_archive_dest, not archive_log_dest...)

Code:

---

ALTER SYSTEM SET log_archive_dest='location=/u01/oradata/archive reopen';
ALTER SYSTEM ARCHIVE LOG ALL;

---