Oracle 12cR2.
Error:
channel default: deleting archived log(s)
archived log file name=+RECO/.../thread_1_seq_166200.26582.1054942673 RECID=62 STAMP=1054943183
archived log file name=+RECO/.../thread_1_seq_166201.11529.1054941077 thread=1 sequence=166201
channel default: deleting archived log(s)
archived log file name=+RECO/.../thread_2_seq_223357.10403.1054942671 RECID=58 STAMP=1054943182
unable to find archived log
archived log thread=2 sequence=223358
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 4 needs more recovery to be consistent
ORA-01110: data file 4: '+DATA/.../data_d...fno-4'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/28/2020 00:24:13
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 223358 and starting SCN of 1871183322646
My commands:
restore primary controlfile from '/.../RESTORE/..._controlfile_20201027_....rman';
alter database mount;
restore database preview;
The final output part of 'restore database preview;' command:
recovery will be done up to SCN 1871164140237
Media recovery start SCN is 1871164140237
Recovery must be done beyond SCN 1871183871662 to clear datafile fuzziness
Finished restore at 27-OCT-20
catalog start with '/.../RESTORE/';
run
{
set newname for database to '+DATA/.../%U' ;
set newname for tempfile 1 to '+DATA/.../%U';
set newname for tempfile 2 to '+DATA/.../%U';
set newname for tempfile 3 to '+DATA/.../%U';
set newname for tempfile 4 to '+DATA/.../%U';
set newname for tempfile 5 to '+DATA/.../%U';
set until scn 1871183871663;
restore database;
switch datafile all;
switch tempfile all;
recover database;
}
NOTE: all of the full database backuppieces, archivelog backups, daily spfile backup and daily controlfile backup are under this path '/.../RESTORE/'.
I setted my limit to scn 1871183871663 (Recovery must be done beyond SCN 1871183871662 to clear datafile fuzziness + 1) but it says "media recovery requesting unknown archived log for thread 2 with sequence 223358 and starting SCN of 1871183322646."
I couldn't find any clear solution. How can I resolve it?
Best regards,
