Solved

Oracle DB:  Does Oracle DB engine recognize available space?

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

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 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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 …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

856 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