ORA-00257: archiver error -- but I've got a lot of free space!

From: Alexander Prohorenko <alexander.prohorenko_at_gmail.com>
Date: 24 Jan 2005 05:27:46 -0800
Message-ID: <1106573266.027374.323520@f14g2000cwb.googlegroups.com>

Hi!

I've got the following message tomorrow, trying to connect to the database.

ORA-00257: archiver error. Connect internal only, until freed.

However, I've got more the 30 gigs for /u02/oradata/oradb/ (where the database files and redo logs are stored) and for /u03/flash_recovery_area/ORADB/archivelog/ (where the backup is performed to). Do you have any ideas on why does it happen?

Here's what I can find out:

sys_at_ORADB> archive log next
ORA-16014: log 1 sequence# 8 not archived, no available destinations ORA-00312: online log 1 thread 1: '/u02/oradata/oradb/redo01.log'

sys_at_ORADB> archive log all
ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST sys_at_ORADB> alter system archive log all to '/u02/oradata/oradb/archive';

System altered.

sys_at_ORADB> shutdown abort;
ORACLE instance shut down.

sys_at_ORADB> startup;
ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size                   778212 bytes
Variable Size              95428636 bytes
Database Buffers           71303168 bytes
Redo Buffers                 262144 bytes

Database mounted.
ORA-16014: log 1 sequence# 11 not archived, no available destinations ORA-00312: online log 1 thread 1: '/u02/oradata/oradb/redo01.log'

I read a lot about this, tried
http://www.idevelopment.info/data/Oracle/DBA_tips/Backup_and_Recovery/BandR_5.shtml and many other advices, but they didn't work. Am I doing something wrong?

Thank you and looking forward your help. Received on Mon Jan 24 2005 - 07:27:46 CST