Re: cannot spool the mounted standby database through cron job shell script. Any other suggestions?

Standard question with common cron issues ... are you sourcing your
environment so all oracle parameters are set correctly ?

On Mon, Jun 27, 2011 at 2:10 PM, sundar mahadevan <
sundarmahadevan82@xxxxxxxxx> wrote:

> Hi All,
> Greetings. I have a standby in mount state. I would like to query the
> latest archive log applied on standby (in mount state) to apply the archive
> logs from primary with a cron job shell script. When i query "select
> max(sequence#) from v\$log_history;" from a shell script it works. But if i
> set it up as cron job as below, it does not work. I cannot assign the output
> to a shell variable since the database is not open and it would crap out.
> Any other suggestions? And the reason for this behaviour? Thanks a lot in
> advance.

Other related posts: