Oracle ORA-00257
su - oracle
sqlplus /nolog
conn / as sysdba
select * from v$flash_recovery_area_usage;
select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
alter system set db_recovery_file_dest_size=8g;
清理archivelog
show parameter recover;
删除归档日志
rman操作
rman
connect target sys/Dminjection!
crosscheck backup;
delete obsolete;
delete expired backup;
crosscheck archivelog all;
delete expired archivelog all;
host;
sqlplus /nolog
connect / as sysdba
select * from v$flash_recovery_area_usage;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步