Hi,

Sometimes You can get “RMAN-06023: no backup or copy of datafile number found to restore ” error.

RMAN-06023: no backup or copy of datafile number found to restore

Details of error are as follows.

RMAN-06023: no backup or copy of datafile number found to restore

Cause: A datafile, tablespace, or database restore could not proceed because no backup or copy of the indicated

file was found. It may be the case that a backup or copy 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-03002: failure of restore command at 03/05/2015 18:03:28
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to 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

Catalog backup pieces

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.

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