Re: stand by DB stop recovery files
- From: "Remigiusz Sokolowski" <remigiusz.sokolowski@xxxxxxxxxx>
- To: <a.lia@xxxxxxxxxx>
- Date: Fri, 27 Aug 2010 11:23:17 +0200
Alessandro Lia pisze:
> this can be useful:
>
> select * from v$archive_gap;
>
> THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
> ---------- ------------- --------------
> 1 131193 132594
>
> ==========================================
> SQL> show parameter fal_client
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> fal_client string
> SQL> show parameter fal_server
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> fal_server string
I would go with what the alert.log says is missing, so
start with setting fal% params to proper value
>
>
> ----- Original Message ----- From: "Ingrid Voigt" <giantpanda@xxxxxxx>
> To: <a.lia@xxxxxxxxxx>; <Oracle-L@xxxxxxxxxxxxx>
> Sent: Friday, August 27, 2010 9:17 AM
> Subject: Re: stand by DB stop recovery files
>
>
>> Is there something in v$archive_gap?
>>
>> What happened to the first log that did not get applied?
>> Is it still on the primary server? Was it transferred
>> to the standby server? Can you transfer and register it
>> manually and what happens then?
>>
>> Are you using data guard broker? If yes, anything unusual
>> in the SHOW results?
>>
>>
>> Regards
>> Ingrid
>>
>>
>> -------- Original-Nachricht --------
>>> Datum: Fri, 27 Aug 2010 08:41:51 +0200
>>> Von: "Alessandro Lia" <a.lia@xxxxxxxxxx>
>>> An: Oracle-L@xxxxxxxxxxxxx
>>> Betreff: stand by DB stop recovery files
>>
>>> Dear all,
>>> I have this situation:
>>> for some reasons I needed to shutdown the physical STAND BY server.
>>> I started up the server and started up the oracle (physical) Stand by DB
>>> following the usual (and so correct) procedure. Everything seems to
>>> be ok
>>> but the DB is not recovering the files.
>>> I ran the query "select sequence#,applied from v$archived_log order
>>> by 1"
>>> and the results (of applied) is NO. I rebooted the server but the
>>> situation
>>> is still the same.
>>> Any experience for such a problem?any suggestion?
>>>
>>> thank you in advance
>>>
>>> Alessandro
>>
>> --
>> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
>> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem:
0000021828,
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
NIP: 586-000-78-20, REGON: 190024711
--
//www.freelists.org/webpage/oracle-l
Other related posts:
