Solved

Oracle DB:  Does Oracle DB engine recognize available space?

Posted on 2015-01-06
4
191 Views
Last Modified: 2015-01-06
Hello team,

We an error message stating the following:
ora00257: archiver error. connect internal only, until freed
we have located a folder(s) worth 75 Gigs and deleted.  However, here is the question.

Q: do we have to bounce the server to recognize the free space or it will without bouncing the server (oracle linux)
thx

JohnE
0
Comment
Question by:John Esraelo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

Author Comment

by:John Esraelo
ID: 40534699
correction:
of course oracle db engine will recognize the free space.  the correct question would be ::
would be quicker to recognize if the server is bounced?
thx

JohnE
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40534709
The error is due to exceeding the value set by the spfile parameter db_recovery_file_dest_size:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#r2c1-t29

This is typically due to the archived redo logs filling up its destination up to db_recovery_file_dest_size.

Just deleting files doesn't do anything.

Even if you delete the archived redo logs, they are still 'tracked' in the control file and must be 'deleted' through RMAN.

To 'fix' the error:
Increase the value for DB_RECOVERY_FILE_DEST_SIZE or delete archived redo logs using RMAN.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40534716
To add:
If you are in archived redo mode, DO NOT delete archived redo log files unless you are 100% sure you have them backed up so you can recover from ANY failure.

If you have free disk space the best option is to set the spfile parameter to give Oracle more space to use.

Your backup strategy should have actions to remove archived redo log files when necessary.
0
 

Author Closing Comment

by:John Esraelo
ID: 40534904
Thank you very much.. tremendous help
I am new in Oracle but 20 years in MS SQL
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question