Saturday, April 7, 2018

Corrupted archive redo logs on dataguard

ORA-00332: archived log is too small - may be incompletely archived 

Recently we got find corruption in one of the archives which caused the DG failure.

732001557_1_480267.arc is corrupted

on primary

SQL> select BLOCKS, BLOCK_SIZE from v$archived_log where SEQUENCE# = 480267;

    BLOCKS BLOCK_SIZE
---------- ----------
   2482577        512

SQL> select BLOCKS, BLOCK_SIZE from v$archived_log where SEQUENCE# = 480268;

    BLOCKS BLOCK_SIZE
---------- ----------
   1434007        512


On standby

[HPSM]-->dbfsize 732001557_1_480267.arc
732001557_1_480267.arc: Header block file size is bad;            trying raw file format...
732001557_1_480267.arc: Header block magic number is bad
[oracle@amxd:/HPSM/arch01]
[HPSM]-->dbfsize 732001557_1_480268.arc

Database file: 732001557_1_480268.arc
Database file type: file system
Database file size: 1434007 512 byte blocks
[oracle@amxd:/HPSM/arch01]


Excerpt from alert log

Errors in file /HPSM/ora01/10.2.0/admin/HPSM/udump/HPSM_ora_11666286.trc:
ORA-00332: archived log is too small - may be incompletely archived
ORA-00334: archived log: '/HPSM/arch01/732001557_1_480267.arc'
Errors with log /HPSM/arch01/732001557_1_480267.arc
ORA-332 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Tue Apr 12 01:05:30 2016

Looks like archive log is not copied properly from production to standby and file is not available in production server

Please help in restoring the archive log 732001557_1_480267.arc from backup.
732001557_1_482215.arc

732001557_1_482216.arc

RMAN> run {
2> allocate channel C1 device type SBT_TAPE  PARMS='BLKSIZE=1048576, SBT_LIBRARY=/GPRD/ora01/10.2.0/lib/libddobk.so, ENV=(STORAGE_UNIT=RMAN,BACKUP_HOST=amxp10ddom01.kci.com,ORACLE_HOME=/GPRD/ora01/10.2.0)';
3>  restore archivelog logseq 482215 ;
4> release channel t1;
5> }



ORA-1237

MOS doc suggest to make more space on data file FS.
We need to request for more space on both the servers (Primary and Standby) as datafile FS have very less free space



No comments:

Post a Comment