My Oracle Support Banner

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

Last updated on OCTOBER 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

+ 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


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