Oracle rman恢复脚本

Oracle rman时间点恢复脚本

1.restore database

RMAN> delete backup;
RMAN> catalog start with '/oracle/rman';

RMAN> run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
set newname for database to '/oracle/app/oracle/oradata/emrtest/%b';
set until time "to_date('20250626 18:28:00' , 'yyyymmdd hh24:mi:ss')";
restore database;
switch datafile all;
switch tempfile all;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}

或

RMAN> run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
set newname for database to '/oracle/app/oracle/oradata/emrtest/%b';
set until time "to_date('20250626 18:28:00' , 'yyyymmdd hh24:mi:ss')";
restore database;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}

RMAN> switch database to copy;

2.recover database

RMAN> run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
set until time "to_date('20250626 18:28:00' , 'yyyymmdd hh24:mi:ss')";
recover database;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}

3.restore archivelog

https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta008.htm

restore archivelog all;   还原全部归档日志文件
restore archivelog from logseq 127912 ;  还原log sequence为127912之后的所有归档日志
restore archivelog from logseq 127912 until logseq 127918; 还原log sequence为127912到127918这几个归档日志
restore archivelog from time 'sysdate-7'; 还原七天以内的归档日志
restore archivelog until logseq 127918; 还原到seqence 为127918的日志文件为止
set archivelog destination to '/data/archivelog/';设定还原日志文件到新路径，

 run{
     set archivelog destination to '/data/archivelog';
     restore archivelog low logseq 127912;
}