Online DBA

<<Back to Oracle Backup & Recovery Main Page RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time Cause:- you have performed open resetlogs operation before the restore. Solution:- Choose correct incarnation and perform the restore RMAN> list incarnation; List of Database Incarnations DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1       1       ORCL1212 2146849107       PARENT  1          07-JUL-14 2       2       ORCL1212 2146849107       PARENT  1594143    09-MAY-19 3       3       ORCL1212 2146849107       PARENT  1704309    09-MAY-19 4       4       ORCL1212 2146849107       CURRENT 1865322    16-MAY-19 RMAN> RESET DATABASE TO INCARNATION 3; database reset to incarnation 3 RMAN> RUN {   set until time= "to_date('16.05.2019 21:20:00','dd.mm.yyyy hh24:mi:ss')";   RESTORE DATABASE;   RECOVER DATABASE; }