RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Hi,

Sometimes You can get  “RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece ” error.

 

Details of error are as follows.

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
Cause: A restore could not proceed because no AUTOBACKUP was found or specified handle is not a valid copy
or backup piece. In case of restore from AUTOBACKUP, it may be the case that a backup exists,
but it does not satisfy the criteria specified in the user’s restore operands. In case of restore from handle,
it may be the handle is not a backup piece or control file copy. In may be that it does not exist.
Action: Modify AUTOBACKUP search criteria or verify the handle.

RMAN> restore controlfile from autobackup;

Starting restore at 28-APR-20
using channel ORA_DISK_1

channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/28/2020 14:15:16
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

RMAN>





 

This error is related with the CONTROLFILE AUTOBACKUP location, configure it where your Controlfile backups located.

 

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rman/%F';

 

Then Restore it again as follows.

RMAN> restore controlfile from autobackup;

 

or

Try it as follows.

 

RMAN> restore controlfile from autobackup db_recovery_file_dest='/backup/rman/%F' db_name=MSDB;

Starting restore at 28-APR-20
using channel ORA_DISK_1
recovery area destination: /backup/rman/%F
database name (or database unique name) used for search: MSDB
channel ORA_DISK_1: no AUTOBACKUPS found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20200420
channel ORA_DISK_1: AUTOBACKUP found: c-653876876-20200420-04
channel ORA_DISK_1: restoring spfile from AUTOBACKUP c-653876876-20200420-04
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 28-APR-20

RMAN>

 

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/

 

 505 views last month,  4 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

blank

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