Scenario:
- RMAN backp where made in this folder:
/xxx/yyyy
- Database was accidentally erased.
- For weird reason, backup pieces are no longer in
/xxx/yyyy
, they are now in/aaa/bbb
- I do an startup nomount, restore controlfile from new location
/aaa/bbb
- I put the DB in mount mode.
- When I try to restore the BD it fails because backup pieces and not found (restored controlfile says backup pieces should be in
/xxx/yyyy
) - I try so set
CHANNEL DEVICE TYPE DISK FORMAT
to the new location (/aaaa/bbb) hoping that RMAN is smart enough to find the backup pieces, but that cannot be done with a backup controlfile.
How can I restore in this scenario where I do have all my backups in another folder than originally backed up to?