Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using oracle database 11g. Some day's back we have deleted our Archivelog Manually, and now it's getting full and due to that we are not able to connect to our database.

So how should i delete archivelog files :

Is there any way by which we can delete archivelog through rman without connecting to the target database.

Or can we increase the archivelog disk space.

Thanks for the reply.

share|improve this question
Hi Sham, you really need to get some training on Oracle, or spend a couple days (at the very least) reading the admin guide. You're setting yourself up for major disasters if you don't understand how the database works. – Mat Dec 19 '12 at 7:15

Deleting archivelog data would normally be done as part of the backup operation removing older archive data after a new backup is taken.

You should read the following:

Only after reading all that should you look at the Backup and Recovery guides section on Configuring an Archived Redo Log Deletion Policy. I purposely did not provide a direct link. When you are ready, you can lookup the book in the Master Book List.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.