Skip to Content
0
Former Member
Jul 20, 2009 at 05:28 PM

Archive log fails on oracle hot standby DB after adding a datafile to live

28 Views

Hi ,

Archive log fails on oracle hot standby DB after adding a datafile to live production database. Our Hot standby DB has five hours delay from the Production database. When we add a datafile with Production database, we have to wait five hours to the point when archive log fails in Hot standby database, then we add the datafile to hot standby db, and reapply the failed archive log and it works.

I am wondering for a solution if it is possible to add datafile production and hot standby at the same time. Is there any solution handy?