查看db_recovery_file_dest_size参数设置:
show parameter db_recovery_file_dest
查看db_recovery_file_dest使用情况:
select * from v$recovery_file_dest;
更改db_recovery_file_dest_size大小:
alter system set db_recovery_file_size=200G
如果日志满了关闭数据库卡住,又启动不起来,可以:
先nolog启动:
shutdown abort
startup mount后删除日志,再alter database open
删除日志:
rman target /
crosscheck archivelog all;
delete archivelog until time 'sysdata-7'删除7天前的日志
11gbug删不掉 加force
delete noprompt force archivelog all completed before 'sysdate-7;
备份数据库并删除日志:
export ORACLE_SID=xxxx
rman target /
backup database plus archivelog delete input;