unable to recover datafile due to missing archived logs
I am unable to do a recovery on one datafile because I do not have all the archived logs needed for the recovery. The archived logs had been properly backed up, but then those backups were deleted before anyone noticed that one datafile in the database was in status RECOVER, and that those backups of archived logs would be needed. RMAN fails to do the recovery because it cannot find the archived logs.
This datafile contains 30 partitions of one table, which is a child of another table via foreign key. I checked the parent table, and there is no data for the range covered by those partitions. Therefore, although the partitions are in that datafile, the partitions are empty -- there is no data therein. So I tried to just drop those partitions, but the ALTER TABLE ... DROP PARTITION failed with