rman常用命令

查看时间段需要恢复的归档
RMAN> list backup of archivelog time between "to_date('2023-08-02 00:10:00','yyyy-mm-dd,hh24:mi:ss')"  and "to_date('2023-08-02 03:03:03','yyyy-mm-dd hh24:mi:ss')";

#加载不在控制文件记录中的归档，并删除6小时前的全部归档-路径根据实际调整
RMAN> catalog start with '/archivelog' noprompt;     
RMAN>crosscheck archivelog all;
RMAN>delete noprompt archivelog until time 'sysdate-1/4';

 #按备份策略要求未被删除的过期备份 处理-路径根据实际调整

RMAN> catalog start with '/backup/orcl/' noprompt;
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> delete noprompt expired backup device type disk;
RMAN> delete noprompt obsolete device type disk ;

ADG环境，主库恢复归档方式-主库做rman备份情况

备库上查看归档日志有没有GAP

SQL> select * from v$archive_gap;

以下是生产库中操作

RMAN> restore archivelog from sequence 128402 until sequence 128445;

RAC环境下需要加上Thread Number，不加默认是Thread 1

RMAN> restore archivelog from sequence 112 thread 2;

恢复Sequence范围

RMAN> restore archivelog from sequence 90 until sequence 98;

RMAN> restore archivelog sequence between 20 and 35;

恢复某个时间段的归档

run {

allocate channel c1 type disk;

allocate channel c2 type disk;

SQL 'ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS"';

restore archivelog time between '2021-06-19 15:00:00' and '2021-06-25 16:00:00';

}

自定义时间获取scn号
select timestamp_to_scn(to_date('2023-08-19 00:20:20','yyyy-mm-dd hh24:mi:ss')) scn from dual;