Sample Header Ad - 728x90

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