Forum Stats

  • 3,826,755 Users
  • 2,260,705 Discussions


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

User_FQQEU Member Posts: 4 Blue Ribbon

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.