RMAN recover and restore from non default location
We have implemented RMAN to replace our conventional hot backup process
We are using ASM and disk based backups are getting written to +FRA disk group
We are using IMAGE COPIES backup and retention policy is set to recovery window of 1 day
After the RMAN backup to disk is completed, We are using DBMS_FILE_TRANSFER.cOPY_FILE to copy the RMAN backup to a locally mounted ("/backup")remote network location
While copying the image copy datafiles we are adding .dbf suffix and for the spfile and control file backup peice, we are adding .cfspf
for example, from +FRA, the image copy backup file users.1082.691212123 would be copied to the network location "/backup" as users.1082.691212123.dbf