2 Replies Latest reply: Nov 17, 2012 4:19 AM by LaserSoft RSS

    failover (realtime apply)


      With regards to performing a failover,

      If I use a real-time recovery with standby logs, Do I still need to issue below command in the primary database ?

      ALTER SYSTEM FLUSH REDO TO target_db_name
        • 1. Re: failover (realtime apply)
          Since you can use Real-time apply, but cannot guarantee that its always working I see do reason not to perform :

          SQL> ALTER SYSTEM FLUSH REDO TO target_db_name;

          During a Failover to a Physical Standby Database.

          Seems the the worst thing that can happen is there no redo to flush.

          Best Regards

          • 2. Re: failover (realtime apply)

            Even in a failover scenario if the primary database can be mounted, it may be possible to flush any unsent archived and current redo from the primary database to the standby database. If this operation is successful, a zero data loss failover is possible even if the primary database is not in a zero data loss data protection mode.

            Ensure that Redo Apply is active at the target standby database.

            1. Mount the Primary database.
            2. alter system flush redo to <target_db_name> (i.e specify db_unique_name)
            3. This will flushes any unsent redo from primary database to the standby database
            4. No data will loose using this option.

            Hope it is clear...