Avatar of sqlagent007
sqlagent007Flag for United States of America asked on

Oracle 10G on windows re-sync the "db_recovery_file_dest_size" wih the OS?

Is there a way to re-sync what Oracle sees as the "db_recovery_file_dest_size" and what Windows shows as available space?

I have over 200GB of free space on my the D:\ drive of my windows server, yet every month or so Oracle will just shut off user connections and show the error of:

"ORA-00257: archiver error. Connect internal only, until freed."

I can clearly see there is enough disk space for Oracle to keep archiving, however it just stops.

Please help, this has become very frustrating.
Oracle Database

Avatar of undefined
Last Comment
gatorvip

8/22/2022 - Mon
gatorvip

Those two are not really related.

As sys, run this:
> show parameter db_recovery_file_dest_size

That will tell you how much recovery space is set in Oracle. Check out this link for an explanation of this parameter:
http://www.ucertify.com/article/what-is-the-db_recovery_file_dest_size-initialization-parameter.html

ASKER
sqlagent007

I have 150GB as the value, I guess I will increase it to 200GB. I thought I heard an Oracle DBA talking about Oracle with WINDOWS and how, oracle and windows do not automatically synchronize. He was saying even if I delete every log file and every backup file from the "show parameter db_recovery_file_dest" directory, ORACLE will not recognize that the space is free until I run some command telling ORACLE to recheck the actual disk space. As luck would have it...I can't find that email, and I need that command. Any help would be greatly appreciated.....
ASKER CERTIFIED SOLUTION
gatorvip

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
sqlagent007

OK, so as of right now I have 160 GB of free space on my D:\drive, however I am now getting the error of "ORA-00257: archiver error. Connect internal only, until freed.". Everything is on the D:\drive, I only have C and D. No oracle files exist on C:\.

I don't think the backups ran last night because of this issue. Please help me figure out what the root cause of this is. I don't know that could be causing this or what to do....
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
sqlagent007

I am running these commands:

delete noprompt expired archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;

Will that tell Oracle that there really is 160GB of free space. Thanks for all your help, I think the RMAN commands is what he told me to do last time.

gatorvip

That should do it. However, if you delete all your archivelogs, make sure you take a full database backup immediately after that.
ASKER
sqlagent007

Thank you sir! You were spot on, the RMAN stuff is exactly what I needed.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
gatorvip

Glad to hear it all worked out!

In order to avoid running into this issue again, I would further suggest that you run periodical backups that delete the archivelogs (you can make a batch file which you can schedule to run at specific times in Windows Task Scheduler)