3 Replies Latest reply: Sep 18, 2012 2:21 PM by mseberg RSS

    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.
        • 1. Re: Impact of force_logging on standby database in 10g?
          mseberg
          Hello;

          I cannot see any issues with turning on force_logging on the Primary except if you wait too long you might have a sync issue. I would do it ASAP.

          Force Logging Feature in Oracle Database [ID 174951.1]

          Best Regards

          mseberg
          • 2. Re: Impact of force_logging on standby database in 10g?
            771417
            So turning force_logging ON now would not impact the setup of standby database using hotbackup from pre force_loging ON period?

            Would the archive logs handle all the changes taken place in between?


            Thanks for the help.
            • 3. Re: Impact of force_logging on standby database in 10g?
              mseberg
              No it won't because the hot backup is a copy period. So do it ASAP and the Archive will handle the rest.

              So your hot backup is the Standby copy ( exact copy ). Just make sure forced logging is on and the archive with keep the data in sync.

              If you delay then you are up the creek without a paddle as NOLOGGING actions are bound to occur and then the Standby data will not match the Primary.

              If you have doubts your best option is to roll the standby forward using RMAN Incremental Backups :

              http://www.oracle-ckpt.com/?s=incremental&op.x=31&op.y=11

              Best Regards

              mseberg