I have some problem while restore the database in separate environment.
This My backup policy and retention
I have monthly full database backup on march the backup started 2nd march 15:31 and completed at 03 march 11:12 AM retention period 3 years
We have ADHOC ARCHIVE backup which will run for certain conditions if the file system threshold reach 80%
In between the monthly backup the ADHOC ARCHIVE jobs has executed from 03Mar2011 00:00 to 03Mar2011 05:14 this retention period is 30 days
So while restore the database with the help of monthly backup i can't able to recover the the datafiles due to adhoc archive files are missing.
If there is any way to rectify this situation