1.在Impdp导入数据的时候报错:

ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 268435456 bytes disk space from 5368709120 bytes limit
2023-04-01T07:25:16.635336+08:00

2.需要扩大闪回区大小http://www.cndba.cn/hbhe0316/article/116517http://www.cndba.cn/hbhe0316/article/116517http://www.cndba.cn/hbhe0316/article/116517http://www.cndba.cn/hbhe0316/article/116517

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oradata/fast_recovery_area
db_recovery_file_dest_size           big integer 5G
recovery_parallelism                 integer     0
remote_recovery_file_dest            string
SQL> alter system set db_recovery_file_dest_size=20G scope=both;

System altered.

SQL>  show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oradata/fast_recovery_area
db_recovery_file_dest_size           big integer 20G
recovery_parallelism                 integer     0
remote_recovery_file_dest            string

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle