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> }
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