1.设置会话时间格式

    1. alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

    2.模拟误删除记录时间点

    1. update hr.employees set salary=100 ;

    3.一致性关闭数据启动到mount

    1. RMAN> shutdown immediate;
    2. RMAN> startup mount;

    4.执行恢复

    1. run{
    2. set until time "to_date('2019-09-18 03:24:00','yyyy-mm-dd hh24:mi:ss')";
    3. restore database;
    4. recover database;
    5. }

    5.非一致性resetlogs open打开数据库

    1. alter database open resetlogs;