Re: stand by DB stop recovery files

  • From: "Ingrid Voigt" <giantpanda@xxxxxxx>
  • To: a.lia@xxxxxxxxxx, Oracle-L@xxxxxxxxxxxxx
  • 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? 


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


Other related posts: