214
💡 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
==============================================