Tip

Archive logs file system is exhausted

Problem:

The disk file system filled up and the archiver was hung. I removed the archive logs and issued an "alter system switch logfile;" hoping to bump the archiver into starting but it did not work. I didn't want to take the production database down, so what could I do?

Solution:

Issue a "show parameter log_archive" to see if you are using a multiple destination option log_archive_dest1 or a single one, i.e., log_archive_dest.

If single destination issue:

SQL>  alter system  set log_archive_dest='' ;
 
System altered.

Then change it to a location where you have room (could be the original location after cleaning up the old archive logs).

SQL>  alter system  set log_archive_dest='/some_directory_with_space/'
 
System altered.

If all went as expected the arch proc should be back on track and no reboot is required.

If multiple archive_dest(1-x) change to single and follow the above steps.

Reader feedback:

Roland F. writes:

From reading the problem, it appears to me the person removed the files which would have freed up the space. I am assuming the person then needed to issue the alter system archive log start command to restart the archive process. Where the solution provided just redirected the archive logs to a different storage area. I think the problem would still be the archiver not being started. Maybe I am missing something here, but that is my two cents. Thanks.

    Requires Free Membership to View

Sachin G. writes:

I think by this solution you will face the same issue as before. Since you are making some free space in the archive destination and you still have the problem, then what is the use of changing the archive destination? Probably the practical solution will be to increase the log_archive_max_processes to high.

This was first published in June 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.