<<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
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;
}
{
set until time= "to_date('16.05.2019 21:20:00','dd.mm.yyyy hh24:mi:ss')";
RESTORE DATABASE;
RECOVER DATABASE;
}
==========================================================================
Troubleshooting Log History
RMAN> RUN
{
set until time= "to_date('16.05.2019 21:20:00','dd.mm.yyyy hh24:mi:ss')";
RESTORE DATABASE;
RECOVER DATABASE;
}
executing command: SET until clause
Starting restore at 16-MAY-19
Starting implicit crosscheck backup at 16-MAY-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/16/2019 21:43:38
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
{
set until time= "to_date('16.05.2019 21:20:00','dd.mm.yyyy hh24:mi:ss')";
RESTORE DATABASE;
RECOVER DATABASE;
}
executing command: SET until clause
Starting restore at 16-MAY-19
Starting implicit crosscheck backup at 16-MAY-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/16/2019 21:43:38
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
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
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> 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 CURRENT 1704309 09-MAY-19
4 4 ORCL1212 2146849107 ORPHAN 1865322 16-MAY-19
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 CURRENT 1704309 09-MAY-19
4 4 ORCL1212 2146849107 ORPHAN 1865322 16-MAY-19
RMAN> RUN
{
set until time= "to_date('16.05.2019 21:20:00','dd.mm.yyyy hh24:mi:ss')";
RESTORE DATABASE;
RECOVER DATABASE;
}
executing command: SET until clause
Starting restore at 16-MAY-19
Starting implicit crosscheck backup at 16-MAY-19
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
Crosschecked 11 objects
Finished implicit crosscheck backup at 16-MAY-19
Starting implicit crosscheck copy at 16-MAY-19
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 16-MAY-19
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fra/ORCL1212/autobackup/2019_05_16/o1_mf_s_1008451629_gfvgdgp5_.bkp
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/orcl1212/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl1212/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl1212/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/orcl1212/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/product/12.1/db_1/dbs/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_nnndf_DADAJI_gfvfks3k_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_nnndf_DADAJI_gfvfks3k_.bkp tag=DADAJI
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 16-MAY-19
Starting recover at 16-MAY-19
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 8 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_8_gfvfp9qn_.arc
archived log for thread 1 with sequence 9 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_9_gfvfvw3z_.arc
archived log for thread 1 with sequence 10 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_10_gfvfwx7w_.arc
archived log for thread 1 with sequence 11 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_11_gfvgcym2_.arc
archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_12_gfvgcynj_.arc
archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_13_gfvgcygp_.arc
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=7
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_annnn_DADAJI_ARCH_gfvfnrl2_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_annnn_DADAJI_ARCH_gfvfnrl2_.bkp tag=DADAJI-ARCH
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_7_gfvhsd71_.arc thread=1 sequence=7
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_7_gfvhsd71_.arc RECID=27 STAMP=1008453068
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_8_gfvfp9qn_.arc thread=1 sequence=8
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_9_gfvfvw3z_.arc thread=1 sequence=9
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_10_gfvfwx7w_.arc thread=1 sequence=10
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_11_gfvgcym2_.arc thread=1 sequence=11
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_12_gfvgcynj_.arc thread=1 sequence=12
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_13_gfvgcygp_.arc thread=1 sequence=13
media recovery complete, elapsed time: 00:00:01
Finished recover at 16-MAY-19
{
set until time= "to_date('16.05.2019 21:20:00','dd.mm.yyyy hh24:mi:ss')";
RESTORE DATABASE;
RECOVER DATABASE;
}
executing command: SET until clause
Starting restore at 16-MAY-19
Starting implicit crosscheck backup at 16-MAY-19
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
Crosschecked 11 objects
Finished implicit crosscheck backup at 16-MAY-19
Starting implicit crosscheck copy at 16-MAY-19
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 16-MAY-19
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fra/ORCL1212/autobackup/2019_05_16/o1_mf_s_1008451629_gfvgdgp5_.bkp
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/orcl1212/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl1212/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl1212/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/orcl1212/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/product/12.1/db_1/dbs/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_nnndf_DADAJI_gfvfks3k_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_nnndf_DADAJI_gfvfks3k_.bkp tag=DADAJI
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 16-MAY-19
Starting recover at 16-MAY-19
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 8 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_8_gfvfp9qn_.arc
archived log for thread 1 with sequence 9 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_9_gfvfvw3z_.arc
archived log for thread 1 with sequence 10 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_10_gfvfwx7w_.arc
archived log for thread 1 with sequence 11 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_11_gfvgcym2_.arc
archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_12_gfvgcynj_.arc
archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_13_gfvgcygp_.arc
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=7
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_annnn_DADAJI_ARCH_gfvfnrl2_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fra/ORCL1212/backupset/2019_05_16/o1_mf_annnn_DADAJI_ARCH_gfvfnrl2_.bkp tag=DADAJI-ARCH
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_7_gfvhsd71_.arc thread=1 sequence=7
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_7_gfvhsd71_.arc RECID=27 STAMP=1008453068
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_8_gfvfp9qn_.arc thread=1 sequence=8
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_9_gfvfvw3z_.arc thread=1 sequence=9
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_10_gfvfwx7w_.arc thread=1 sequence=10
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_11_gfvgcym2_.arc thread=1 sequence=11
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_12_gfvgcynj_.arc thread=1 sequence=12
archived log file name=/u01/app/oracle/fra/ORCL1212/archivelog/2019_05_16/o1_mf_1_13_gfvgcygp_.arc thread=1 sequence=13
media recovery complete, elapsed time: 00:00:01
Finished recover at 16-MAY-19
RMAN> alter database open resetlogs;
Statement processed
Statement processed
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 ORPHAN 1865322 16-MAY-19
5 5 ORCL1212 2146849107 CURRENT 1865481 16-MAY-19
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 ORPHAN 1865322 16-MAY-19
5 5 ORCL1212 2146849107 CURRENT 1865481 16-MAY-19
Comments
Post a Comment