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 126.96.36.199 and later
Information in this document applies to any platform.
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
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
From Standby Alertt Log
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)
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