Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle DB:  Does Oracle DB engine recognize available space?

Posted on 2015-01-06
4
Medium Priority
?
204 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
  • 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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 78

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

824 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