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

I faced an error last night when I was going to recover my 12c database after restoration new environment.

 

ERROR:

RMAN-03002: failure of recover command at 11/28/2023 06:12:57
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/path/to/recovery file destination/o1_mf_1_235860_lpbxjrbh_.arc'
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
 

REASON:
There has been no memory allocated to 8K or 16K or 32K block buffers cache. Explicitly allocating memory to the non-default block buffers will resolve the ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K or 16K or 32K errors
 

ACTION:

1. log in the database
2. check parameter DB_16K_CACHE_SIZE and set value
 

SQL> show parameter DB_16K_CACHE_SIZE;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size                    big integer 0
SQL>

SQL> alter system set DB_16K_CACHE_SIZE=10M scope = spfile;
 

3. restart the database and

 

SQL> shutdown immediate;
Database dismounted.
ORACLE instance shut down.
 

SQL> startup mount;
ORACLE instance started.
 
Total System Global Area 1.2482E+10 bytes
Fixed Size                  8939000 bytes
Variable Size            1744830464 bytes
Database Buffers         1.0704E+10 bytes
Redo Buffers               24612864 bytes
Database mounted.
 
 

4. check value set correctly

 

SQL> show parameter DB_16K_CACHE_SIZE;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size                    big integer 64M
SQL>
SQL>
SQL>
SQL> exit

 

4. recover database now. It working fine now.