Re: Standby 8i and Message ORA-279
From: ddf <oratune_at_msn.com>
Date: Mon, 24 Aug 2009 06:28:32 -0700 (PDT)
Message-ID: <c0f8e0cb-d727-44e8-bc59-e340f0448e5a_at_v36g2000yqv.googlegroups.com>
On Aug 22, 8:08 am, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:
> Hello,
>
> I have a production database and a standby under 8i.
> I transfer the archived redo from the production to the standby by script.
>
> Regularly on the standby a script is executed to apply the redo transfered
> on the standby.
>
> The script execute this command :
>
> set autorecovery on
> recover standby database
>
> Everytime Oracle execute my script and apply the redo, I get ORA-279 message
> in the alert.log.
> Oracle always write this message in the alert.log before playing the redo
> logs.
>
> For example, redo files with the sequence 100, 101 and 102 are in the
> directory of the standby.
> The recover is executed by script and I get the message :
>
> ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
> ALTER DATABASE RECOVER CONTINUE DEFAULT
>
> And in the spool file of my command I can see the ORA-00279, ORA-00289 ... :
>
> ORA-00279: change 51667831821 generated at 07/02/2009 01:19:40 needed for
> thread 1
> ORA-00289: suggestion : /nodal-archive/archive/1_55121_652209172.arc
> ORA-00280: change 51667831821 for thread 1 is in sequence #55121
> ORA-00278: log file '/nodal-archive/archive/1_55120_652209172.arc' no longer
> needed for this recovery
>
> Message ORA-279 before applying each archived redo is a normal behavior ?
>
> Tha,ks for your help
> fabrice.
Date: Mon, 24 Aug 2009 06:28:32 -0700 (PDT)
Message-ID: <c0f8e0cb-d727-44e8-bc59-e340f0448e5a_at_v36g2000yqv.googlegroups.com>
On Aug 22, 8:08 am, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:
> Hello,
>
> I have a production database and a standby under 8i.
> I transfer the archived redo from the production to the standby by script.
>
> Regularly on the standby a script is executed to apply the redo transfered
> on the standby.
>
> The script execute this command :
>
> set autorecovery on
> recover standby database
>
> Everytime Oracle execute my script and apply the redo, I get ORA-279 message
> in the alert.log.
> Oracle always write this message in the alert.log before playing the redo
> logs.
>
> For example, redo files with the sequence 100, 101 and 102 are in the
> directory of the standby.
> The recover is executed by script and I get the message :
>
> ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
> ALTER DATABASE RECOVER CONTINUE DEFAULT
>
> And in the spool file of my command I can see the ORA-00279, ORA-00289 ... :
>
> ORA-00279: change 51667831821 generated at 07/02/2009 01:19:40 needed for
> thread 1
> ORA-00289: suggestion : /nodal-archive/archive/1_55121_652209172.arc
> ORA-00280: change 51667831821 for thread 1 is in sequence #55121
> ORA-00278: log file '/nodal-archive/archive/1_55120_652209172.arc' no longer
> needed for this recovery
>
> Message ORA-279 before applying each archived redo is a normal behavior ?
>
> Tha,ks for your help
> fabrice.
I see no disconnect in this script, so is this running in the same session which started from a previous run of this script? The error appears to be notifying you that autorecovery is already on.
David Fitzjarrell Received on Mon Aug 24 2009 - 08:28:32 CDT