ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K

xiaoxiao2021-02-28  43

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。

转载请注明原文地址: https://www.6miu.com/read-2626356.html

最新回复(0)