Skip to content

How to Resolve ORA-32005: error while parsing size specification

  • by

ORA-32005

When I tried to increase the size of Fast Recovery Area (FRA) from 1TB to 1.5TB, it failed with ORA-32005.

SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 1T
SQL> alter system set db_recovery_file_dest_size=1.5T sid='*' scope=both;
alter system set db_recovery_file_dest_size=1.5T sid='*' scope=both
*
ERROR at line 1:
ORA-32005: error while parsing size specification [1.5T]

ORA-32005 means that the value you want to set to a parameter does not match the specification, you should correct it to an acceptable value.

Solutions

In this case, we use 1.5T, a float number with decimal point to set DB_RECOVERY_FILE_DEST_SIZE, which is not acceptable to the parameter, the only acceptable number type is integer.

In Terabyte (TB)

To solve ORA-32005, we can change 1.5 into 2, an integer value to make it pass.

SQL> alter system set db_recovery_file_dest_size=2T sid='*' scope=both;

System altered.

SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 2T

Although there only Kilobyte (KB), Megabyte (MB) and Gigabyte (GB) are listed as valid units for DB_RECOVERY_FILE_DEST_SIZE in the official documentation, we can use Terabyte (TB) without problem.

In Gigabyte (GB)

If you really want to set FRA as 1.5TB, you should convert it into gigabyte, which is 1536GB.

SQL> alter system set db_recovery_file_dest_size=1536G sid='*' scope=both;

System altered.

SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 1536G

Both ways are workable as long as you use an integer.

To make the disk space work for your database, you have to know how to enable FRA.

Leave a Reply

Your email address will not be published.