Re: stand by DB stop recovery files

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#CIHIAADC
You 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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: