Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 20, 2009 at 05:55 PM

    what is your Oracle version?

    We had the same issue back in 2005 and we used the same manual procedure as you.

    to lower the risk, we created multiple datafiles in advance with small size and used auto-extend options.

    Add comment
    10|10000 characters needed characters exceeded