Re: stand by DB stop recovery files

  • From: "Alessandro Lia" <a.lia@xxxxxxxxxx>
  • To: "Ingrid Voigt" <giantpanda@xxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 27 Aug 2010 09:42:40 +0200

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
----- 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2010