RDBMS 11.2.0.4 .Dataguard.
在备库的alert log上看到告警:
MRP0: Background Media Recovery terminated with error 379
Errors in file /u01/app/oracle/diag/rdbms/test_stdby/test_stdby/trace/test_stdby _mrp0_8398.trc:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K
Recovery interrupted!
Recovered data files to a consistent state at change 22642585
MRP0: Background Media Recovery process shutdown (test_stdby)
在备库上查询dba_data_file。出现错误
SYS@test_stdby>select file_name from dba_data_files;
ERROR:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K
原因:
是因为在主库上建立了blocksize 为32K的表,而主库上设置了db_32k_cache_size.但是备库上没有设置。
在备库上设置后,mrp进程正常。查询dba_data_files也正常。
End。