Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-00289 (suggestion) path wrong for STANDBY instance

ORA-00289 (suggestion) path wrong for STANDBY instance

From: <utefan001_at_gmail.com>
Date: 19 Oct 2006 15:14:55 -0700
Message-ID: <1161296095.850656.91340@e3g2000cwe.googlegroups.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 Received on Thu Oct 19 2006 - 17:14:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US