Re: ORA-00289 (suggestion) path wrong for STANDBY instance

From: <utefan001_at_gmail.com>
Date: 20 Oct 2006 09:14:20 -0700
Message-ID: <1161360860.570221.245850@e3g2000cwe.googlegroups.com>

This is what the output is.....

SQL> show parameter standby

NAME                                 TYPE    VALUE
------------------------------------ -------
------------------------------
standby_archive_dest                 string

/oradata/prod/gprod/standby

I found a workaround though. I am just copying the files to the "archive" directory. That way I was able to use the AUTO feature.

joel garry wrote:
> utefan001_at_gmail.com wrote:
>
> > Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> > *** I would like to choose AUTO, but I can't because the "suggestion"
> > path is wrong.***
> >
> > ***********************Partial initSID.ora***********************
> > # The following are the log parameters for the standby site
> > Log_Archive_Start = True
> > Log_Archive_Format = gprod_%s.arc
> > Log_Archive_Dest_1='LOCATIonfiltered=/oradata/prod/gprod/archive/'
> > Log_Archive_Dest_state_1=enable
> > standby_archive_dest=/oradata/prod/gprod/standby
> > **************************************************************************
> >
> > If more info is needed, let me know.
>
> What do you see when you
> show parameter standby
> ?
>
> The guess being you are looking at something different than reality,
> like the wrong init.ora.
>
> jg
> --
> @home.com is bogus.
> http://www.soundportraits.org/on-air/execution_tapes/complete_audio.php3
Received on Fri Oct 20 2006 - 11:14:20 CDT