This discussion is archived
3 Replies Latest reply: Feb 12, 2009 9:34 PM by 316993 RSS

ALTER DATABASE ADD STANDBY LOGFILE GROUP

DBA2011 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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... Guru
    Currently Being Moderated
    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
    316993 Pro
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points