首页 > 代码库 > ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K

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

在做异机迁移恢复数据库时,报如下错误。

PSDRPC returns significant error 1013.

PSDRPC returns significant error 1013.

PSDRPC returns significant error 1013.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/03/2017 04:43:22

RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile ‘+DATA/dbtx/archivelog/2017_03_03/thread_2_seq_9187.323.937629789‘

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

RMAN> 

   因为之前设置了db_32k_cache_size参数,并且建立了32k block_size大小的表空间,但是现在用的参数文件无db_32k_cache_size参数,导致无法为相应的块按照32k的block_size来分配buffer cache,因此参数文件中加入db_32k_cache_size参数问题解决。

本文出自 “技术成就梦想!” 博客,请务必保留此出处http://dreamsanqin.blog.51cto.com/845412/1903192

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