Get the App
SLTechnology News&Howtos  ›  Database  › 

ORA-00379: no free buffers ava

Shulou Source: shulou.com Published: 2022-06-01 22:16:37 11月15日 Update

When doing an off-machine migration to recover the database, the following error is reported.

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 >

Because the db_32k_cache_size parameter was previously set and the 32k block_size size table space was established, but the parameter file used now has no db_32k_cache_size parameter, so it is impossible to allocate buffer cache according to the 32k block_size for the corresponding block, so the problem of adding db_32k_cache_size parameter to the parameter file is solved.

Tags: Parameters file size data database space error problem add assign Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux OPPO Reno vpn Docker macOS