RMAN-06026: some targets not found - aborting restore

<<Back to Oracle Backup & Recovery Main Page

RMAN-06026 and RMAN-06100

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/11/2018 15:10:33
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 27
Cause: There could be few possible reasons of this issue
The actual issue is RMAN-06026: some targets not found - aborting restore

CAUSE1:The problem here is that there are some files in the Flash Recovery Area that belong to different incarnation than the available backups CURRENT incarnation.
We can check that there are not backups belonging to CURRENT incarnation with command
RMAN> LIST BACKUP RECOVERABLE;
Solution:disable Flash Recovery Area and try the restore again
create init.ora file from spfile
SQL> create pfile from spfile;
Edit the init.ora and comment the db_recovery_file_dest entries
#*.db_recovery_file_dest='<directory>'
#*.db_recovery_file_dest_size=<size>
Start the database with modified init.ora
SQL> shutdown;
SQL> startup nomount pfile='.... init.ora'

CAUSE2:Check if the backup is correct and it includes all the needed files in backup
Solution: Take good backup and try to restore from good backup
For Example
RMAN> RUN
{
  ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 10G;
  BACKUP
  FORMAT '/u01/app/oracle/stage/%d_D_%T_%u_s%s_p%p'
  DATABASE
  PLUS ARCHIVELOG
  FORMAT '/u01/app/oracle/stage/%d_A_%T_%u_s%s_p%p';
  RELEASE CHANNEL ch11;
}