Re: Standby database looking for old archive
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: Roman Podshivalov <roman.podshivalov@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 25 Feb 2008 12:40:02 -0800 (PST)
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.
K
Roman Podshivalov <roman.podshivalov@xxxxxxxxx> 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....
--romas
On 2/25/08, kathy duret <katpopins21@xxxxxxxxx> wrote: 1000% sure... I did
this again just to be sure.
Roman Podshivalov <roman.podshivalov@xxxxxxxxx> 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 ?
--romas
On 2/25/08, kathy duret <katpopins21@xxxxxxxxx> 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.
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 your homepage.
---------------------------------
Never miss a thing. Make Yahoo your homepage.
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Other related posts:
