Cuentos de un DBA: Backup de RMAN a un NFS

Posted by Paola Pullas | Posted in Base de Datos | Posted on 04-06-2013

Tags: , , ,

1

Ayer estaba intentando enviar un backup de RMAN a un NFS y RMAN me arrojaba como error que el directorio NFS no había sido montado con las opciones correctas. El error exacto es: ORA-27054: NFS file system where the file is created or resides is not mounted with correct options.

Este error se puede presentar cuando están trabajando con RMAN o expdp e intentan trabajar con un NFS que no tiene la opción “noac” seteada.

La solución en este caso es guardar los respaldos de RMAN o del utilitario expdp en otra ubicación o setear el evento que detallo a continuación a nivel de la base de datos:

ALTER SYSTEM SET EVENTS ’10298 trace name context forever, level 32′;

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.





Resumen de Oracle CPU’s Liberados

Posted by Paola Pullas | Posted in Noticias, Seguridad | Posted on 04-10-2009

Tags: , ,

0

Los CPU’s o Critical Patch Updates son “fixes” de seguridad para los productos Oracle, los cuales están liberados para aquellos clientes que tienen contratos válidos de soporte. Estos “fixes” son liberados los martes próximos al quinceavo día de Enero, Abril, Julio y Octubre. A continuación se despliegan las fechas de los próximos CPU’s a ser liberados, en donde podrán notar que hay un retraso para el mes en curso debido a la realización del Oracle Open World 2009:

  • 20 October 2009
  • 12 January 2010
  • 13 April 2010
  • 13 July 2010

Cada CPU que se publica es pre-anunciado el jueves anterior a su liberación y se debe tomar en cuenta que a partir del enero de 2008 se publica la información en OTN y no en Metalink.


Critical Patch Update

MetaLink Note

Latest Version/Date
Critical Patch Update
– July 2009
No MetaLink copy Rev 3, 03 September 2009
Critical Patch Update – April 2009 No MetaLink copy Rev 4, 03 September 2009
Critical Patch Update – January 2009 No MetaLink copy Rev 4, 03 September 2009
Critical Patch Update – October 2008 No MetaLink copy Rev 3, 03 September 2009
Critical Patch Update – July 2008 No MetaLink copy Rev 3, 05 March 2009
Critical Patch Update – April 2008 No MetaLink copy Rev 4, 22 May 2008
Critical Patch Update – January 2008 No MetaLink copy Rev 1, 15 January 2008
Critical Patch Update – October 2007 455284.1 Rev 1, 16 October 2007
Critical Patch Update – July 2007 432865.1 Rev 2, 19 July 2007
Critical Patch Update – April 2007 420055.1 Rev 2, 18 April 2007
Critical Patch Update – January 2007 403335.1 Rev 2, 05 March 2007
Critical Patch Update – October 2006 391558.1 Rev 4, 06 March 2006
Critical Patch Update – July 2006 372927.1 Rev 1, 18 July 2006
Critical Patch Update – April 2006 360044.1 Rev 1, 18 April 2006
Critical Patch Update – January 2006 343382.1 Rev 1, 17 January 2006
Critical Patch Update – October 2005 333953.1 Rev 2, 19 December 2005
Critical Patch Update – July 2005 311034.1 Rev 1, 12 July 2005
Critical Patch Update – April 2005 301040.1 Rev 2, 13 April 2005
Critical Patch Update – January 2005 293953.1 Rev 2, 15 March 2005

Autor: Paola Pullas