DataGuard
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: DataGuard

  1. #1
    Join Date
    Nov 2004
    Location
    Chennai, INDIA
    Posts
    16

    DataGuard

    Hi,

    We are in the process of implementing Standby DB (Physical). We are running our production db in oracle9i RAC with two instances(in IBM AIX5.2 with HACMP 5.2 Cluster). We would like to send the archived redo log files from Primary DB to StandbyDB with time frequency rather than sending the archivelog files to standby destination as and when it got generated.

    For doing the above, is there any utility / unix scripts to compress and send the archive log files to the standby destination with defined time frequency....if any such utility/scripts available it will be very useful for us.....


    thanks....in advance...

    ramesh
    Ramesh V

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    Hi,
    You can delay the application of archived redo logs on the standby by the command
    Code:
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 
    And to return it to default mode ie no delay,
    Code:
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY;

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Re: DataGuard

    Originally posted by ramesh_v
    Hi,

    We are in the process of implementing Standby DB (Physical). We are running our production db in oracle9i RAC with two instances(in IBM AIX5.2 with HACMP 5.2 Cluster). We would like to send the archived redo log files from Primary DB to StandbyDB with time frequency rather than sending the archivelog files to standby destination as and when it got generated.

    For doing the above, is there any utility / unix scripts to compress and send the archive log files to the standby destination with defined time frequency....if any such utility/scripts available it will be very useful for us.....


    thanks....in advance...

    ramesh
    I'm confused....if you have RAC why do you want to do standby as well?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  4. #4
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    I'm confused....if you have RAC why do you want to do standby as well?
    I did think about that aswell. Is there any particular reason why you would want to do that?

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Re: DataGuard

    Originally posted by OracleDoc
    I'm confused....if you have RAC why do you want to do standby as well?
    RAC = high availability
    Standby = disaster recovery

    In RAC environment, in most cases all the nodes of the cluster are located in the same geographical location, usualy in the same building/room. So for example if the ceiling of that building colapses, probably all the nodes of the RAC will be damaged. So what good does it do that you had RAC? That is why it is not unusual to have a standby database on some distant location that covers you in the events of such "environmental disasters".
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: Re: Re: DataGuard

    Originally posted by jmodic
    RAC = high availability
    Standby = disaster recovery

    In RAC environment, in most cases all the nodes of the cluster are located in the same geographical location, usualy in the same building/room. So for example if the ceiling of that building colapses, probably all the nodes of the RAC will be damaged. So what good does it do that you had RAC? That is why it is not unusual to have a standby database on some distant location that covers you in the events of such "environmental disasters".
    you could also have a local standby in case you need to do PIT recovery quickly - ergo a time delay
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    Or have a read-only version of the database used for reporting purposes.

  8. #8
    Join Date
    Feb 2002
    Posts
    70
    Set ARCHIVE_LAG_TARGET to an integer value.
    If you set it to 0 (zero) then it is disabled. One can alter the value by ALTER SYSTEM...


    ARCHIVE_LAG_TARGET limits the amount of data that can be lost and effectively increases the availability of the standby database by forcing a log switch after the specified amount of time elapses.

    A 0 value disables the time-based thread advance feature; otherwise, the value represents the number of seconds. Values larger than 7200 seconds are not of much use in maintaining a reasonable lag in the standby database. The typical, or recommended value is 1800 (30 minutes). Extremely low values can result in frequent log switches,
    which could degrade performance; such values can also make the archiver process too busy to archive the continuously generated logs.

    Thanks,
    ________________
    ShanDJ

  9. #9
    Join Date
    Nov 2004
    Location
    Chennai, INDIA
    Posts
    16
    Thanks....

    Actually we are planning to implement DR Site with physical standby DB (both primary and standby will run in Oracle9i RAC). Our DB size is around 350gb, and the redo generation is around 30gb per day.
    Sending the archivelog files in online requires more mbps leased lines, instead of that we and to compress the archivelog file in the primar site itself and sending to DR site in specific interval of time (once in 30min or 1hr). For this we need some kind of a deamon program running in both primary and DR site which will send and received the compressed archivedlog file and uncompress it and putting it in the actual archivelog folder of the DR site.

    Please suggest some kind of utility for this.......

    thanks
    Ramesh V

  10. #10
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by ramesh_v
    Thanks....

    Actually we are planning to implement DR Site with physical standby DB (both primary and standby will run in Oracle9i RAC). Our DB size is around 350gb, and the redo generation is around 30gb per day.
    Sending the archivelog files in online requires more mbps leased lines, instead of that we and to compress the archivelog file in the primar site itself and sending to DR site in specific interval of time (once in 30min or 1hr). For this we need some kind of a deamon program running in both primary and DR site which will send and received the compressed archivedlog file and uncompress it and putting it in the actual archivelog folder of the DR site.

    Please suggest some kind of utility for this.......

    thanks
    won't you defeat the automatic gap resolution process by doing this?
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width