Ora-19804: Cannot reclaim 45561856 bytes disk space from 8589934592 limit

时间:2022-09-24 10:37:51

启动数据库到Nomount: startup nomount

扩大闪回恢复区的大小:show parameter db_recovery

执行SQL语句:alter system set db_recovery_file_dest_size=5g scope=both;

打开数据库:alter database mount;

打开数据库:alter database open;

进入RMAN模式:rman target sys/admin nocatalog

RMAN删除过期的备份文件与归档文件:delete backupset;

RMAN删除过期的备份文件与归档文件:delete archivelog all;

检查一下Flashrecovery Area的使用情况:select * from v$flash_recovery_area_usage;

此时数据库可以正常访问