Home » RDBMS Server » Server Administration » ORA-00257: archiver error. Connect internal only, until freed. (Oracle 10g RHEL 4)
ORA-00257: archiver error. Connect internal only, until freed. [message #331040] Wed, 02 July 2008 03:49 Go to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi,
I am getting the error ORA-00257: archiver error. Connect internal only, until freed.

I am able to solve it for now by increasing the DB_RECOVERY_FILE_DEST_SIZE .

How can I do it without increasing the DB_RECOVERY_FILE_DEST_SIZE.



SQL> show parameter db_recovery_file_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /data0/app/oracle/flash_recovery_area

db_recovery_file_dest_size big integer 6G

SQL> SELECT * FROM V$RECOVERY_FILE_DEST;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/data0/app/oracle/flash_recovery_area
6442450944 4449029120 0 94


I delete some files from /data0/app/oracle/flash_recovery_area but still that is not reduced from SPACE_USED.

How can this be done.

Thanks in advance..
Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331045 is a reply to message #331040] Wed, 02 July 2008 03:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You can have a look at,
http://arjudba.blogspot.com/2008/04/ora-00257-archiver-error-connect.html
to know how to solve it without increasing size.
Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331133 is a reply to message #331040] Wed, 02 July 2008 06:03 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi,
I have deleted the archivelog using the following commands.


$rman target /
RMAN>delete archivelog until time 'SYSDATE-1';

before doing this i deleted some files manually us "rm -rf" Oracle still shows that space as occupied, as those files are not properly deleted is there any way i can reclaim the space.

SQL> SELECT * FROM V$RECOVERY_FILE_DEST;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/data0/app/oracle/flash_recovery_area
6442450944 2449565696 0 53

while total number of files is not 53 in the filesystem .


Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331320 is a reply to message #331040] Thu, 03 July 2008 00:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

crosscheck archivelog all;
Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331355 is a reply to message #331040] Thu, 03 July 2008 02:06 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi,

The output of crosscheck command is shown below(not full output).

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_20/o1_mf_1_264_45qptdd2_.arc recid=1 stamp=657928871
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_265_45r1oj89_.arc recid=2 stamp=657939979
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_266_45rf9g69_.arc recid=3 stamp=657951881
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_267_45rlxpj1_.arc recid=4 stamp=657957649
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_268_45rv681w_.arc recid=5 stamp=657966113
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_269_45s6hmbn_.arc recid=6 stamp=657977676



I am getting error "validation failed for archived log" for the files which I have deleted using "rm -rf" . that space still remains claimed as used by oracle.

Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331357 is a reply to message #331355] Thu, 03 July 2008 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Now "delete expired".

I think you should read Database Backup and Recovery Reference.

Regards
Michel
Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331623 is a reply to message #331355] Fri, 04 July 2008 04:29 Go to previous message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Thanks Michel,Arju Smile

delete expired archivelog all; worked.

Previous Topic: Setting db_keep_cache_size
Next Topic: linux and oracle 9i
Goto Forum:
  


Current Time: Sat Dec 03 11:57:23 CST 2016

Total time taken to generate the page: 0.09844 seconds