Dataguard - Manual Archive Logs Update

[reachriah]

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.

[pando]

that is all automatic why you wanna do that manually?

[davey23uk]

write your own shell script.

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

[waitecj]

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.

[reachriah]

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..

[davey23uk]

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