1.创建还原点
无保障还原点,在控制文件中可能过时,最多2048个
create restore point rest_01;
有保障还原点
create restore point rest_01 guarantee flashback database;
2.查看还原点
select name,time,scn,database_incarnation# from v$restore_point;
3.基于还原点恢复
startup mount;
restore database until restore point p1;
recover database until restore point p1;
alter database open resetlogs;