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

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 27 Jun 2011 14:31:19 -0400
Message-ID: <BANLkTi=RTq3a_C2T-pzeoALX9dQXm8E3pQ_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 27 2011 - 13:31:19 CDT