IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “RMAN-06025: no backup of archived log for thread number with sequence number and starting SCN of string found to restore ” error.
Details of error are as follows.
RMAN-06025: no backup of archived log for thread number with sequence number and starting SCN of string found to restoreCause: An archived log restore restore could not proceed because no backup of the indicated archived log
was found. It may be the case that a backup of this file exists but does not satisfy the criteria
specified in the user’s restore operands.
Action: None – this is an informational message. See message 6026 for further details.
RMAN-06026: some targets not found – aborting restore
RMAN-06025: no backup of log thread 1 seq 41 lowscn 4532641 found to restore
RMAN-06025: no backup of log thread 1 seq 42 lowscn 4532640 found to restore
RMAN-06025: no backup of log thread 1 seq 43 lowscn 4532638 found to restore
RMAN-06025: no backup of log thread 1 seq 41 lowscn 4532641 found to restore
RMAN-06025: no backup of log thread 1 seq 42 lowscn 4532640 found to restore
RMAN-06025: no backup of log thread 1 seq 43 lowscn 4532638 found to restore
This error is related with the Catalog database problem, If you don’t use catalog database or catalog connection is broken, you can get this error.
Try to restore them without Catalog database as follows.
RMAN> restore archivelog from time='SYSDATE-7' validate;
Or if you have catalog database, connect it and run the following command.
rman connect catalog user/pwd@CATALOG_DB connect target / RMAN>
RMAN> RESTORE ARCHIVELOG ALL VALIDATE;
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
Muchas gracias, funcionó muy bien!
you are welcome.