Re: stand by DB stop recovery files
Date: Fri, 27 Aug 2010 09:17:57 +0200
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?
- Original-Nachricht --------
> Datum: Fri, 27 Aug 2010 08:41:51 +0200
> Von: "Alessandro Lia" <a.lia_at_tct-it.com>
> An: Oracle-L_at_FreeLists.org
> 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
-- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 27 2010 - 02:17:57 CDT