NMDA: some targets not found - aborting restore RMAN-06025: no backup of log thread 1 seq 1 lowscn 1164241 found to restore

RMAN command 'RESTORE ARCHIVELOG ALL VALIDATE' failing with error:
RMAN-06025: no backup of archived log for thread number with sequence number and starting SCN of string found to restore.
 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/04/2021 17:33:02
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 1 lowscn 1164241 found to restore

1. The NetWorker Management Console wizard, allows for the backup and recover operations of NMDA Oracle, however it is not able to conduct these operations on Oracle RAC environments.

2. In this situation even though the destination host was a stand-alone machine, the source computer was part of an Oracle RAC configuration, which the wizard is not able to navigate.

3.  The issue is caused when not using catalog database or no catalog connection is used.
 
4. "ALL" keyword in "RESTORE ARCHIVELOG ALL VALIDATE" statement does not take into account backup retention policy but tries to access all archived redo logs referenced in RMAN repository.

Action Plan: 

🟆  The recovery wizard does not support Cluster or Oracle RAC systems.  Use RMAN command-line interface to perform Oracle restore in such environments. 

Then try to check and proceed with either of the following Options :-

Option A:

🟆 Using only the controlfile, no catalog database used:
 
🟆 Use the below syntax from RMAN command prompt, for validating archive log backups.
 
 
1) RMAN> restore archivelog from time='<RECOVERY WINDOWS DAYS#>' validate;
 
Suppose you have set the recovery window of 7 days, then use the below command.
 
 
2) RMAN> show RETENTION POLICY;
 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
 
3) RMAN> restore archive log from time='SYSDATE-7' validate;
 
Starting restore at 13-JAN-12
Using channel ORA_DISK_1
 
channel ORA_DISK_1: starting validation of archive log backupset
channel ORA_DISK_1: reading from backup piece <path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T111853_7JZKG717_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=<path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T111853_7JZKG717_.BKP tag=TAG20120113T111853
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting validation of archive log backupset
channel ORA_DISK_1: reading from backup piece <path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T112054_7JZKL018_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=<path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T112054_7JZKL018_.BKP tag=TAG20120113T112054
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
Finished restore at 13-JAN-12
 
RMAN>
 
 
Option B:

🟆 If you have recovery catalog configured, connect to target database and recovery catalog, and "RESTORE ARCHIVELOG ALL VALIDATE;" works without errors.
 
🟆 Rman target / catalog <username>/<password>@<catalog_tns>
 
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jan 13 11:37:11 2012
 
Copyright (c) 1982, 2007, Oracle. All rights reserved.
 
Connected to target database: <dbname> (DBID=<dbid>)
Connected to recovery catalog database
 
🟆 RMAN> RESTORE ARCHIVELOG ALL VALIDATE;
 
Starting restore at 13-JAN-12
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid=35 devtype=DISK
 
channel ORA_DISK_1: starting validation of archive log backupset
channel ORA_DISK_1: reading from backup piece <path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T111853_7JZKG717_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=<path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T111853_7JZKG717_.BKP tag=TAG20120113T111853
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting validation of archive log backupset
channel ORA_DISK_1: reading from backup piece v\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T112054_7JZKL018_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=<path>\BACKUPSET\2012_01_13\O1_MF_ANNNN_TAG20120113T112054_7JZKL018_.BKP tag=TAG20120113T112054
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
Finished restore at 13-JAN-12
 
RMAN>

 
Action: None - this is an informational message. See message 6026 for further details.
 

Starting restore at 04-DEC-21

released channel: t0
released channel: t1
released channel: t2
released channel: t3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/04/2021 17:33:02
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 2 with sequence 447871 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447870 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447869 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447868 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447867 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447866 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447865 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447864 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447863 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447862 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447861 and star
RMAN-06025: no backup of archived log for thread 2 with sequence 447860 and star