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

Last updated on AUGUST 17, 2011

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

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