RMAN-06053: unable to perform media recovery because of missing log

Hi,

Sometimes You can get ” RMAN-06053: unable to perform media recovery because of missing log ” error.

 

Details of error are as follows.

RMAN-06053: unable to perform media recovery because of missing log

Cause: This message is accompanied with another message identifying the missing log.
The log would be needed to perform the media recovery, but the log is not on disk and no backup set
containing the log is available.


Action: Determine if a backup set containing the log can be made available. If so, then use the CHANGE
command to make the backup set available and retry the command. If not, then a point in time recovery
up to the missing log is the only alternative.


RMAN-03002: failure of recover command at 12/31/2019 18:03:00
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 46823 lowscn 4317596780 found to restore

RMAN>

 

 

 

To solve this error, recover database until previous 46823 sequence.

 

RMAN> run {
 set until sequence 46822;

 recover database;

}

Determine if a backup set containing the log can be made available. If so, then use the CHANGE command to make the backup set available and retry the command. If not, then a point in time recovery up to the missing log is the only alternative.

 

 

 

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/

 

 446 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply