RE: Standby database looking for old archive

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: "'kathy duret'" <katpopins21@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 25 Feb 2008 12:30:33 -0500

The only way I've personally seen that is if the tablespaces had been left
in backup mode for weeks on the primary. If I recall correctly it doesn't
complain or else only complains at the warning level if you put a tablespace
in backup mode that is already in backup mode, so it might not be obvious.

 

Hmm - but that does not explain having the same problem when you copied the
files over again, because you ended backup, had the problem, began backup
again, copied the files, ended backup, switched the logfile, waited for the
logs to be on the standby, and then still had the same problem.

 

Are any tablespaces offline on the primary? I guess, unless someone has an
actual solution from a similar experience, the next step is to verify one to
one correspondence of files from the primary to the standby and that nothing
is offline or in media failure on the primary.

 

  _____  

From: kathy duret [mailto:katpopins21@xxxxxxxxx] 
Sent: Monday, February 25, 2008 12:20 PM
To: Mark W. Farnham; oracle-l@xxxxxxxxxxxxx
Subject: RE: Standby database looking for old archive

 

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.  

 

K

"Mark W. Farnham" <mwf@xxxxxxxx> 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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Finn Jorgensen
Sent: Monday, February 25, 2008 11:12 AM
To: katpopins21@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Standby database looking for old archive

 

kathy,

 

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

 

Finn

 

<snip>

 

 

  

  _____  

Never miss a thing. Make Yahoo
<http://us.rd.yahoo.com/evt=51438/*http:/www.yahoo.com/r/hs>  your homepage.


Other related posts: