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;
