ORA-00289 (suggestion) path wrong for STANDBY instance

[utef...@gmail.com]

This was not answered in comp.databases.oracle.server, so... here we
are again.

I have about 100 archive log files on a HP-UX 8i (8.1.7) STANDBY
database that I need to apply. The standby database was down for a few
days because I added a datafile on the primary site and had not added
the datafile to the standby database until today. Now I have a bunch
of archive log files that need to be "manually" caught up.

Can any of you tell me how to get the ORA-00289 (suggestion) line to
point to the path it should be? If you can, I will be able to use the
"AUTO" feature and won't have to apply each log one by one.

bad path = /oradata/prod/gprod/archive/
good path = /oradata/prod/gprod/standby/

SQL> recover standby database;
ORA-00279: change 66605375 generated at 10/13/2006 07:07:33 needed for
thread 1
ORA-00289: suggestion : /oradata/prod/gprod/archive/gprod_14366.arc
***above suggestion path wrong***
ORA-00280: change 66605375 for thread 1 is in sequence #14366

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oradata/prod/gprod/standby/gprod_14366.arc
**above path (typed by me) is correct***
ORA-00279: change 66613103 generated at 10/13/2006 08:10:24 needed for
thread 1
ORA-00289: suggestion : /oradata/prod/gprod/archive/gprod_14367.arc
ORA-00280: change 66613103 for thread 1 is in sequence #14367
ORA-00278: log file '/oradata/prod/gprod/standby/gprod_14366.arc' no
longer
needed for this recovery

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

[joel garry]

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

[utef...@gmail.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.