RMAN-06026: some targets not found – aborting restore

 💡 Alternate client restores of Oracle backups failing with “RMAN-06026: some targets not found – aborting restore”

🚚 Cause

It shows FRA area
==============================================
SQL> show parameter db_recovery_file;

NAME                                TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /path/app/oracle/recovery_area
db_recovery_file_dest_size          big integer 100G
==============================================

Solution

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '';

System altered.

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

System altered.

SQL> show parameter db_recovery_file;

NAME                                TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size          big integer 100G
==============================================

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log