ORA-00332: ARCHIVED LOG IS TOO SMALL - MAY BE INCOMPLETELY ARCHIVED (Doc ID 726580.1)

Last updated on FEBRUARY 08, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 9.0.1.0 to 11.2.0.2 - Release: 9.0.1 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 31-Sep-2010***

Symptoms

The ORA-00332: archived log is too small - may be incompletely archived is reported while applying an archived log to a standby database.

 

SQL> recover [standby] database
ORA-00279: change 234153904069 generated at 06/30/2008 12:31:21 needed for thread 3
ORA-00289: suggestion : /u10/oradata/logdisk/ORCL_3_101698.log
ORA-00280: change 234153904069 for thread 3 is in sequence #101698
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00332: archived log is too small - may be incompletely archived
ORA-00334: archived log: '/u10/oradata/logdisk/ORCL_3_101698.log'

The error will also happen during the recover of a database restored from a backup or while dumping an archived redo log using 'alter system dump logfile'.

SQL> alter system dump LOGFILE '/u10/oradata/logdisk/ORCL_3_101698.log';
alter SYSTEM DUMP LOGFILE '/u10/oradata/logdisk/ORCL_3_101698.log'
*
ERROR at line 1:
ORA-00332: archived log is too small - may be incompletely archived
ORA-00334: archived log: '/u10/oradata/logdisk/ORCL_3_101698.log'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms