Dataguard - Manual Archive Logs Update
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Dataguard - Manual Archive Logs Update

  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Dataguard - Manually Apply Archive Logs

    hi all,
    i have the following scenario with Oracle 10g DataGuard database....
    All the archive log files from the primary are moved to standby. One of my tasks, is to make sure that the moved log files will not get applied immediately to the standby database.....
    My question is in what mode should I keep the standby database for the above to work.
    Next is, I need to write a shell script to apply the archive log files to standby database..... by running the script at specific intervals.... I am wondering if anyone has a script to do this..........

    I need to get this done in a day span .......its very urgent....

    Please post your shell script here .......


    thanks in adv.
    Last edited by reachriah; 11-29-2005 at 12:34 AM.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that is all automatic why you wanna do that manually?

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    write your own shell script.

    But to not apply logs it needs to be in read only, do you know much about dataguard?

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Or you can set up a time lag between log shipping from primary and log apply on standby. Seems like the most sensible aproach for your requirements to me.
    Assistance is Futile...

  5. #5
    Join Date
    Nov 2005
    Posts
    3
    hi all,

    thanks for ur quick reply

    yeah ,standby database is running in read only mode and it is used for report generations.All the archive log files are coming to standby site but they are not applied (i.e not in managed recovery mode)..
    need to write a shell script to apply those archive log files for every 3hrs,for the files which have not applied status in archived_log view.

    please share ur thoughts to write the script..

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    pseudo code

    connect to database
    alter database recover managed standby database disconnect from session;
    exit from sqlplus
    sleep 10800
    connect to database
    alter database recover managed standby database cancel;
    alter database open read only;
    exit


    quite simple really

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