1、查询需要恢复时间段的归档日志
select * from v$archive_log where to_date('2020-05-07 18:32:20','yyyy-mm-dd hh24:mi:ss') between first_time and next_time;
rman> list backup of archivelog from logseq ... until logseq ...;
2、把需要的备份文件注册添加到控制文件
rman> catalog backuppiece '/../../...arc';
3、恢复指定序列号的归档日志
rman> restore archivelog from logseq ... until logseq ...;
4、把归档记录到数据库
rman> catalog archivelog '/../../...arc';
如下是使用备份到虚拟带库的备份片来恢复归档日志的方式
rman>
run{
allocate channel dev_7 type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ynsicp,OB2BARLIST=YNSICP_full_weekly)';
set archivelog destination to '/../'; -- 设置归档恢复时存放的路径，不指定即为归档的默认存放路径
restore archivelog from logseq 37539 until logseq 37567 thread 2;
release channel dev_7;
}
删除3天前的归档
sql 'alter system archive log current';
delete noprompt archivelog until time 'sysdate-3';
