Hi,

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

RMAN-06172

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>

no AUTOBACKUP found or specified handle is not a valid copy or piece

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.

RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA