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