首页 > 代码库 > 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