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: 184.108.40.206
Information in this document applies to any platform.
+ 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
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!