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

Default image

Error: ORA-16765: Redo Apply is running

Default image

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

Default image

check the FRA usage and troubleshoot the issue in oracle DB