oracle 闪回区满了,查看日志报错:ORA-19815,命令行输入:
sqlplus / as sysdba startup mount //如果你的数据库出现了无法连接的情况时,可以加上这句 select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable, number_of_files as "number" from v$flash_recovery_area_usage;
可以看出,archived log 已经100%了
查看现在的空间是多大:
show parameter db_recovery_file_dest
可以看到是30G
增加空间:
alter system set db_recovery_file_dest_size=100G scope=both;
再次查询占用量:
select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable, number_of_files as "number" from v$flash_recovery_area_usage;
重新加载一下数据库
shutdown startup
完成,重新连接数据库,正常