Day 6: Tip Log_Archive_Dest_1 Set To Default in Oracle Database 11.1

Posted by Paola Pullas | Posted in Base de Datos, Oracle, Tips | Posted on 03-10-2010

Tags: , , , ,

7

In this post I want to share with you the information about the Bug 6373164 present in Oracle Database 11.1. This bug was fixed in release 11.1.0.7.0.

Symptoms

I configured Archivelog Mode in my database and set the flash recovery area like the default location to store achivelog files. I configured the next parameters in order to set the flash recovery area:

  • DB_RECOVERY_FILE_DEST
  • DB_RECOVERY_FILE_DEST_SIZE

Other parameters related to Archivelog Mode aren’t configured in my linux box, for example:

  • LOG_ARCHIVE_DEST is not set
  • LOG_ARCHIVE_DEST_n is not set

In the next screen I show you my actual configuration:

When the database starts to generate archivelog files, these was send to flash recovery area location but additionally to $ORACLE_HOME/dbs causing higher disk space utilization in my server, like I show you in the next screen:

How to solve the problem

In order to solve this problem you should change the configuration of LOG_ARCHIVE_DEST_1 parameter with the next command:

  • alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;

Author: Paola Pullas
Do you need to buy support?: Contact me at pp@refundation.com

If you think that this tutorial helped you. Make a donation to this initiative. We appreciate your support. Also your donation can help me to buy more coffee or Red Bull.





Be Sociable, Share!

Comments (7)

You can make use of flax meal, almond meal, soy powder, etc.

I’m impressed, I have to admit. Rarely do I come across a
blog that’s both equally educative and interesting,
and without a doubt, you’ve hit the nail on the head. The problem
is an issue that not enough folks are speaking intelligently
about. I’m very happy I came across this during my hunt for something concerning
this.

Great post. I was checking continuously this blog and I’m impressed!
Very helpful info specially the last part :) I care for such information a
lot. I was seeking this certain info for a very long
time. Thank you and best of luck.

I loved as much as you will receive carried out right here.
The sketch is tasteful, your authored material stylish.
nonetheless, you command get bought an nervousness over that you wish be delivering the following.
unwell unquestionably come more formerly again as exactly the same nearly a
lot often inside case you shield this hike.

Seguidamente los cuatro ganadores de cada liga jugaron una liguilla para dilucidar el
campeonato. 45.

Hmm is anyone else encountering problems with the images on this blog loading?

I’m trying to figure out if its a problem on my end
or if it’s the blog. Any suggestions would be greatly
appreciated.

hi all,
if we have flash recovery area enabled and archives going to be stored in that location but now i want to change the location,and what is the diff bet/n log_archive_dest_1 and db_recovery_file_Dest

Write a comment