3 Replies Latest reply on Sep 18, 2012 7:21 PM by mseberg

    Impact of force_logging on standby database in 10g?

    771417
      Hi there,
      We have a 10.2.0.5 database from which we want to setup a standby database...

      We took a hot backup of the primary and send it to the standby server but at that time we realized that force logging is not enabled at the Primary before we took the hot backup!

      Can you please suggest what are our options at this stage without losing any data and without a need to redo the hot backup again since it is a huge database?

      - If we turn the force_logging on now(on Primary) and then set up the standby using the backup taken prior to force_logging ON - would it cause any issues?

      Any help would be greatly appreciated.

      Thanks.