Hi Alessandro,just a little piece of advice-if the output from v$archive_gap is correct then your (possibly first) gap is 1396 files. This is a lot I think, but it depends on the archive log size.
I have brought a customer's standby back to life after applying approx 1800 of them, but the database was small (450G) and so were the logs (13-40M).
If you find you can't catch up with production, before trashing the standby I recommend you have a look at the backup from scn option:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIAADCYou might have to copy and paste the URL if my email client decided to introduce a line break.
Regards, Martin Niall Litchfield wrote:
Now I look a little closer it may just be that you haven't specified FAL so you'll have to do gap resolution manually anyway.On 27 Aug 2010 08:15, "Alessandro Lia" <a.lia@xxxxxxxxxx <mailto:a.lia@xxxxxxxxxx>> wrote:I put it in manage recovery. This is a message in alert log: Trying FAL server: Error fetching gap sequence, no FAL server specified Fri Aug 27 09:10:20 2010 Failed to request gap sequence. Thread #: 1, gap sequence: 131193-132589 All FAL server has been attempted. Any idea? Alessandro----- Original Message ----- From: "Remigiusz Sokolowski" <remigiusz.sokolowski@xxxxxxxxxx <mailto:remigiusz.sokolowski@xxxxxxxxxx>>To: <a.lia@xxxxxxxxxx <mailto:a.lia@xxxxxxxxxx>> Cc: <Oracle-L@xxxxxxxxxxxxx <mailto:Oracle-L@xxxxxxxxxxxxx>> Sent: Friday, August 27, 2010 8:56 AM Subject: Re: stand by DB stop recovery files Alessandro Lia pisze: > > Dear all, > I have this situation: > for some reasons I needed to shutd...
-- Martin Bach OCM 10g http://martincarstenbach.wordpress.com http://www.linkedin.com/in/martincarstenbach -- //www.freelists.org/webpage/oracle-l
