1.用/nolog账户登陆oracle
sqlplus /nolog;
conn / as sysdba;
2.查看归档日志使用情况
select * from v$flash_recovery_area_usage;
3.查看recovery空间大小级日志所在路径
show parameter recover;
4.退出sql,使用rman工具清理归档日志
dos窗口中登陆rman工具
rman target sys/pass;
5.检查无用的archivelog;
crosscheck archivelog all;
6.删除过期归档日志
delete expired archivelog all;
删除截止到前一个礼拜的所有archivelog;
delete archivelog until time 'sysdate-7';
7.再次查询归档使用情况
select * from v$flash_recovery_area_usage;
8.重启数据库
shutdown immediate;
startup mount;
alter database open;
如果无法登陆,则删除archlog log
select group#,sequence# from v$log;
alter database clear unarchived logfile group 1;
或者是修改recovery大小
alter system set db_recovery_file_dest_size=XXX scope=spfile;
XXX指多少M或G。
阅读(1795) | 评论(0) | 转发(0) |