1.创建还原点
    无保障还原点,在控制文件中可能过时,最多2048个

    1. create restore point rest_01;

    有保障还原点

    1. create restore point rest_01 guarantee flashback database;

    2.查看还原点

    1. select name,time,scn,database_incarnation# from v$restore_point;

    3.基于还原点恢复

    1. startup mount;
    2. restore database until restore point p1;
    3. recover database until restore point p1;
    4. alter database open resetlogs;