Oracle 12cR2 RMAN - ORA-01547, ORA-01194, RMAN-06054
0
votes
1
answer
807
views
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,
Asked by jrdba
(55 rep)
Oct 27, 2020, 10:40 PM
Last activity: Apr 21, 2025, 10:03 PM
Last activity: Apr 21, 2025, 10:03 PM