3 Replies Latest reply: Feb 12, 2009 11:34 PM by orawarebyte RSS

    ALTER DATABASE ADD STANDBY LOGFILE GROUP

    DBA2011
      version 10 & 11g
      creating standby logfile groups on primary db is optional or needed? what could be advantages of both?

      I am reading 2 articles one is creating that other not?
      http://www.orafaq.com/node/2030
      & 736863.1 Notes
        • 1. Re: ALTER DATABASE ADD STANDBY LOGFILE GROUP
          608334
          The following benefits accrue from the standby redo log files:

          During a failover, standby redo logs enable Data Guard to apply more redo data than what is available in the archived redo logs alone.


          Standby redo logs are required to implement the maximum protection and maximum availability levels of data protection (no-data-loss) disaster recovery solutions.


          Standby redo logs are required to implement real time apply.


          Standby redo logs are required for cascaded redo log destinations.
          • 2. Re: ALTER DATABASE ADD STANDBY LOGFILE GROUP
            Anand...
            Well creating the standby logfile is on you.But it is highly recommended to create it for the reason being standby redo log files, enable real-time apply, which allows Data Guard to recover redo data from the current standby redo log file as it is being filled up by the RFS process.So maximum data protection.

            refer to [http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_apply.htm#i1022881]

            HTH
            Anand
            • 3. Re: ALTER DATABASE ADD STANDBY LOGFILE GROUP
              orawarebyte
              DBA2008 wrote:
              version 10 & 11g
              creating standby logfile groups on primary db is optional or needed? what could be advantages of both?
              at primary database it is optional ,but it would be good candidate for switchover activity , it makes ensure that if you make any planned maintenance activity at primary site and switchover within yours data guard environment from primary database to physcial standby database ,if you create standby redo log at primary database it is not in use right now but it will be used when yours primary database switch to standby database after switching to physical standby databsae as a primary database.

              Khurram