RMAN-06026: some targets not found – aborting restore

Hi,

Sometimes You can get ” RMAN-06026: some targets not found – aborting restore ” error.

Details of error are as follows.

RMAN-06026: some targets not found - aborting restore

This error is related with autobackups in FRA ( Flash Recovery Area ), There are backup files but they are belonged to different incarnation than the available backups current incarnation.

To solve this error, reset the db_recovery_file_dest and db_recovery_file_dest_size parameters, and RMAN will not look for these files in the FRA.

SQL> alter system reset db_recovery_file_dest_size scope=spfile sid='*';

System altered.

SQL> alter system reset db_recovery_file_dest scope=spfile sid='*';

System altered.

Restart database as follows.

SQL> shutdown immediate;
SQL> startup

Then try to restore again.

If it is not solved with this action, then Catalog these backup pieces again as follows.

RMAN> catalog start with '/oracle/backup/';

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/