Re: Oracle Standby and RAMN CATALOG

From: Outsider <mufc01666_at_gmail.com>
Date: Fri, 4 Oct 2013 13:02:30 +0200
Message-ID: <CAO6u0XY_uBBuAj6MDaRxTJouOS1WxgAcpFUVBjyVzyvJBVogpQ_at_mail.gmail.com>

Hi Ndidi ,
They are configured in normal way. We have about 25 DB and all this DB use this catalog.

tnsnames

RMANP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =hostname )(PORT = 1521))     (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OCCM1)

    )
  )

lisener

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
(SID_NAME = OCCM1)
(GLOBAL_DBNAME = OCCM1)
(ORACLE_HOME = /opt/oracle/db/11.2.0.3)
    )
    (SID_DESC =
(SID_NAME = OCCM1)
(GLOBAL_DBNAME = OCCM1DG1_DGMGRL)
(ORACLE_HOME = /opt/oracle/db/11.2.0.3)
    )
)

ADR_BASE_LISTENER = /opt/oracle
# TRACE_LEVEL_listener=admin

thanks

*-----------------*

*Tiran*
*Best Regards
Stay in touch...*

On 4 October 2013 12:30, Ndidi Ibeachum <chinedui_at_live.co.uk> wrote:

> How is the tnsnames and listener files configured on the recovery catalog?
>
> ------------------------------
> Date: Fri, 4 Oct 2013 11:39:16 +0200
> Subject: Re: Oracle Standby and RAMN CATALOG
> From: mufc01666_at_gmail.com
> To: chinedui_at_live.co.uk; dedba_at_tpg.com.au; oracle-l_at_freelists.org
>
> Dear Chinedu,
>
> Everything is configured like you said. And strange is that
> this works about 6 months.
>
>
> *-----------------*
> *Tiran*
> *Best Regards
> Stay in touch...*
>
>
> On 4 October 2013 09:28, Ndidi Ibeachum <chinedui_at_live.co.uk> wrote:
>
>
> Dear Tiran;
>
> I have come across a similar problem before. For this to work, A tnsnames
> entry should be present in each database for connection both ways ie. a
> tns names entry from the standby to the primary and vice versa.
> In addition, configure a static listener on both nodes to stand in for the
> tns entries.
>
> Try and feedback.
>
> Cheers
>
> Chinedu
>
>
> > Date: Wed, 2 Oct 2013 12:30:40 +0200
> > Subject: Oracle Standby and RAMN CATALOG
> > From: mufc01666_at_gmail.com
> > To: oracle-l_at_freelists.org
> >
> > Dear experts,
> > I have physical data guard implemented and I also scheduled the backup of
> > database with cron on Linux to IBM tape. Everything was fine for about 6
> > months.
> > few days ago I realized that backup is not performed from standby
> database.
> > After same investigation I found out that this is because RMAN from
> standby
> > DB wants to resync catalog but can't connect to catalog database which is
> > separate database.
> >
> > this is from my log from cron
> >
> > ORA-20079: full resync from primary database is not done
> > > doing automatic resync from primary
> > > resyncing from database with DB_UNIQUE_NAME XYZS1DG1
> > > RMAN-00571: ===========================================================
> > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> > > RMAN-00571: ===========================================================
> > > RMAN-03002: failure of configure command at 10/02/2013 04:00:18
> > > RMAN-03014: implicit resync of recovery catalog failed
> > > RMAN-03009: failure of partial resync command on default channel at
> > > 10/02/2013 04:00:18
> > > ORA-17629: Cannot connect to the remote database server
> > > ORA-17627: ORA-12154: TNS:could not resolve the connect identifier
> > > specified
> > > ORA-17629: Cannot connect to the remote database server
> >
> >
> > I tried to connect via RMAN to catalog and it works.
> >
> > #:~> rman target / catalog XXX/XXX_at_XXX
> >
> > Recovery Manager: Release 11.2.0.3.0 - Production on Wed Oct 2 12:24:05
> 2013
> > > Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
> > > reserved.
> > > connected to target database: XYZS1 (DBID=3537003386)
> > > *connected to recovery catalog database*
> >
> >
> > but when I started resync
> >
> > RMAN> resync catalog;
> > > starting partial resync of recovery catalog
> > > ORA-20079: full resync from primary database is not done
> > > doing automatic resync from primary
> > > resyncing from database with DB_UNIQUE_NAME XYZS1DG1
> > > RMAN-00571: ===========================================================
> > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> > > RMAN-00571: ===========================================================
> > > RMAN-03009: failure of resync command on default channel at 10/02/2013
> > > 12:25:51
> > > ORA-17629: Cannot connect to the remote database server
> > > ORA-17627: ORA-12154: TNS:could not resolve the connect identifier
> > > specified
> > > ORA-17629: Cannot connect to the remote database server
> >
> >
> >
> > How can be this possible ? I not connected to catalog database already ?
> or
> > I am missing something......
> >
> >
> > What I did.
> >
> > I resync catalog from Primary database so Standby not need to resync it
> > again and my backup works well in night but this is only for 1 night.
> Next
> > day again some problem.
> >
> > Please help, advise.
> >
> > Thanks in advance.
> >
> >
> > *-----------------*
> > *Tiran*
> > *Best Regards
> > Stay in touch...*
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 04 2013 - 13:02:30 CEST