Início > Oracle > Oracle 11.2.0.3: Archiver is unable to archive a redo log because the output device is full

Oracle 11.2.0.3: Archiver is unable to archive a redo log because the output device is full

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

This is a typical error when you are running out off archive log space.

In this case my db_recovery_file_dest_size was set to 8GB in a 100GB disk.

So we need to increase this destination size:

 

[oracle@DBPRD ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Jan 20 15:55:32 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     167
Next log sequence to archive   171
Current log sequence           171
SQL>
SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u03/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 8G

SQL> alter system set db_recovery_file_dest_size = 80G;

System Altered

SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u03/app/oracle/fast_recovery_area
db_recovery_file_dest_size           big integer 80G

SQL>

 

 

 

 

 

Categorias:Oracle
  1. Nenhum comentário ainda.
  1. No trackbacks yet.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s

%d blogueiros gostam disto: