Is it possible to apply archivelogs from standby DB to Production DB?

Question

I've lost two hard disks yesterday . One contains an Oracle Datafile and another contains part of archive logs generated in the past 2 days. (say, arch_5.dbf and arch_6.dbf are lost, in the set of arch_1 to arch_10).

I have switched over to my standby site as part of business continuity plan.

Now, I have to recover the missed datafile. It requires the missed two archive log files for recovery.

Is is possible to apply the same set of archivelogs from standby to production, in order to recover the datafile ?

Kindly advise.

~SK~

Answer 1

It might prove a bit easier to Use RMAN Incremental Backups to Refresh a Standby Database you could use the archives that are transported to the standby site but they won't help with the recovery of the lost datafiles, unless their creation is logged in the archives.

Using the incremental backup option is easier.