Oracle DB: Does Oracle DB engine recognize available space?

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
John EsraeloDatabase / SQL DeveloperAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
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
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Thank you very much.. tremendous help
I am new in Oracle but 20 years in MS SQL
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.