Solved

Oracle DB:  Does Oracle DB engine recognize available space?

Posted on 2015-01-06
4
195 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

734 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