Re: stand by DB stop recovery files
- From: "Remigiusz Sokolowski" <remigiusz.sokolowski@xxxxxxxxxx>
- To: <a.lia@xxxxxxxxxx>
- Date: Fri, 27 Aug 2010 08:56:00 +0200
Alessandro Lia pisze:
> 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
0. hard to say anything as Your description is very scarce - I would
even recommend checking if You start managed recovery :-)
1. any errors in alert.log? usually if something wrong there are some
2. are You able to recover when You transfer archivelogs manually? if
yes then something wrong with communication
3. check a communication based upon the settings provided as SERVICE in
log_archive_dest_n
4. check Your other log_archive% and fal% parameters
Regards
Remigiusz
--
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:
