ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
I am trying to restore a database from the backup using untill time. Firstly I restored the database then offline files got skipped then I restored with restore database check readonly; and then trying to recover it and am getting the below error. Please help me on it.
set until time "to_date('20-NOV-2012 20:10:00','DD-MON-YYYY HH24:MI:SS')";
#restore database;
restore database check readonly;
switch datafile all;
recover database;
#RECOVER DATABASE DELETE ARCHIVELOG;
#alter database open resetlogs;
release channel t1;
release channel t2;
Thanks
Nirvair
media recovery failed
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============