My Oracle Support Banner

Physical Standby Media Recovery Process (MRP) terminates with ORA-00379 (Doc ID 1349524.1)

Last updated on DECEMBER 26, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

+ Dataguard configuration with a primary database and a physical standby database
+ Default block size for the database is 8k ie. DB_BLOCK_SIZE=8192
+ A 32K blocksize tablespace is added on primary after which media recovery on standby fails with ORA-00379:

From Primary Alert Log
Sun Aug 14 10:01:51 2011
Thread 1 advanced to log sequence 1590 (LGWR switch)
Sun Aug 14 14:49:11 2011
CREATE TABLESPACE TESTDTA_32K DATAFILE
'/path/TESTDTAT_32K01.DBF' SIZE 1024M AUTOEXTEND ON NEXT 128M MAXSIZE 32767M,
'/path/TESTDTAT_32K02.DBF' SIZE 1024M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M
BLOCKSIZE 32K

From Standby Alertt Log
Sun Aug 14 14:55:22 2011
Archived Log entry 1373 added for thread 1 sequence 1590 rlc 746724243 ID 0xce97910 dest 2:
Sun Aug 14 14:55:25 2011
Media Recovery Log /path/1_1590_746724243.dbf
Sun Aug 14 14:55:49 2011
Recovery created file /path/TESTDTAT_32K01.DBF
Sun Aug 14 14:56:52 2011
Recovery created file /path/TESTDTAT_32K02.DBF
Successfully added datafile 50 to media recovery
Datafile #50: '/path/TESTDTAT_32K01.DBF'
Successfully added datafile 51 to media recovery
Datafile #51: '/path/TESTDTAT_32K02.DBF'
Sun Aug 14 15:05:28 2011
Slave exiting with ORA-379 exception
Errors in file /path/DB_NAME_pr03_11010132.trc:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K
MRP0: Background Media Recovery process shutdown (DB_NAME)


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.