Re: Standby database looking for old archive - solved

From: kathy duret <>
Date: Mon, 25 Feb 2008 13:15:24 -0800 (PST)
Message-ID: <>

I feel so dumb! It was the init.ora!    

  I forgot I was on Windows and I changed the init.ora in the dbs folder instead of the database folder in the $ORACLE_HOME.    

  Man this drove me crazy all day today and it is a very short drive!    

  I added this check to my document so that I check this before I start.    

  Thanks to everyone... But a big Virtual Beer goes to Roman    


Roman Podshivalov <> wrote:

    Looks like you are pointing to old control file somewhere. If you:   select name, status from v$controlfile;   on mounted standby instance if might help you to drill down where exactly.    

  Did you bounce standby instance after you transferred new standby control file ?    


  On 2/25/08, kathy duret <> wrote: The checkpoint change# in all of the v$datafile_headers looks like prod   but all of the checkpoint change# in the v$datafile are the ones looking for the feb 2nd archives.    

  This is very strange.    

  I did recreate the scontrol file as a new name and made sure it was change in the spfile and the pfile.    

  I guess it is back to the drawing board.. I just don't want to recreate this all and have the same issue... I guess I have to log a tar.    


Roman Podshivalov <> wrote:

      Mount it and do:    

  select name, status, recover, fuzzy, CHECKPOINT_CHANGE#, CHECKPOINT_TIME from v$datafile_header;    

  Check if you see anything worth investigating....    


  On 2/25/08, kathy duret <> wrote: 1000% sure... I did this again just to be sure.   

Roman Podshivalov <> wrote: Kathy,    

  Are you 100% sure you've generated and transferred new copy of standby control file(s) ? And restarted standby instance after you did that ?    


  On 2/25/08, kathy duret <> wrote: Yes I ended the backup mode after the file was completed.    

  The current archives are all there. It is calling an archive from weeks ago   which is not there.    


"Mark W. Farnham" <> wrote:

      In exactly the same spirit as Finn, did you ship the log you need after you ended backup mode, er, um, you don't actually write that you ended backup mode and physical recovery cannot complete until a log from after the end backup is applied.           


  From: [] On Behalf Of Finn Jorgensen Sent: Monday, February 25, 2008 11:12 AM To:
Subject: Re: Standby database looking for old archive    


    You don't say this, so I'm going to ask. After you put the tablespaces in hot backup mode and copied them over, did you also copy over archive logs since putting the tablespaces in backup mode up until after you took them back out of backup mode and applied them to the standby? (I know it's obvious, but sometimes....)      



  Never miss a thing. Make Yahoo your homepage.        

  Never miss a thing. Make Yahoo your homepage.          

  Looking for last minute shopping deals? Find them fast with Yahoo! Search.           

Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Received on Mon Feb 25 2008 - 15:15:24 CST

Original text of this message