Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-00289 (suggestion) path wrong for STANDBY instance
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' nolonger
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
If more info is needed, let me know.
Thanks
Received on Thu Oct 19 2006 - 17:14:55 CDT