Dear Friends,
I am cloning a prod database in to a non-prod using a RMAN online Full backup. I took the prod backup to Disk using a TAG name - "BACKUP_FOR_CLONING".
When running clone, RMAN> restore database from TAG "BACKUP_FOR_CLONING"; I encountered an error : "RMAN-06023: no backup or copy of datafile 475 found to restore "
I found that datafile 475 was added when prod backup was in progress. So, the controlfile doesn't recognize it when restoring from TAG ?
The restore worked fine when using "Until time" - RMAN> restore database until time "to_date('06/12/2016 18:16:50','MM/DD/YYYY HH24:MI:SS')"; but not when using the TAG.
What is the difference ? Using TAG will not look for archived logs that might have been generated when backup was in progress (We have archived log backups that run every 4 hours that backup to Tape, we had a couple of jobs that kicked in when Prod Full backup was in progress).
Kindly share your thoughts -