rman 脚本

分类: 文章 • 2022-08-09 19:26:33

run {
sql 'alter session set nls_date_format="yyyy-mm-dd hh34:mi:ss"';
set until time = '2015-08-05 01:59:59';
restore database;
recover database;
alter database open resetlogs;
}

alter database set standby database to maximize performance;

run{
set archivelog destination to 'C:\arch';
restore archivelog from time '2015-08-04 23:00:00' until time '2015-08-05 00:00:01';
}