oracle 归档日志清理

1. 备份数据库

  exp username/password@ip/实例名 file=filepath+filename

2.进行归档日志处理

//查看归档日志详情
select aa.ArchiveDate,aa.ArchiveSize from (
select trunc(first_time) as ArchiveDate,
sum(block_size * blocks) / 1024 / 1024 / 1024 as ArchiveSize
from v$archived_log
group by trunc(first_time)
) aa order by aa.ArchiveDate desc

//查看在数据库中记录的有多少条
select * from v$controlfile_record_section where type='ARCHIVED LOG';

使用catalog start with 命令重新注册这些失效文件到控制文件中

1.进入RMAN 编辑模式下 执行以下名利 /u01/app/oracle/oradata/orcl为‘存放归档日志的文件夹’
catalog start with '/u01/app/oracle/oradata/orcl'; 

2.进行删除命令 删除一个月以前的归档日志。
delete noprompt archivelog until time 'sysdate-30';
上面命令 报RMAN- 08137 就用下面的命令强制删除
delete force noprompt archivelog until time 'sysdate-30'

2.进行无效日志清理
crosscheck archivelog all; 
delete expired archivelog all;