Fwd: Oracle Standby and RAMN CATALOG

From: Outsider <mufc01666_at_gmail.com>
Date: Fri, 4 Oct 2013 11:40:44 +0200
Message-ID: <CAO6u0XYNXziDcryh20T=5OA3V4q9PFa7iWCXw2ygZORyCHmihg_at_mail.gmail.com>

Hi Tony,
Thanks for reply,

I checked again but everything is OK. The replication is working fine between primary and standby. I tried to resync catalog from standby. Look

~> rman target XXX/XXX auxiliary XXX/XXX_at_XXX (log_archive_config) catalog XXX/XXX_at_XXX
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 4 11:29:00 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
connected to auxiliary database: XYZS1 (DBID=3537003386)

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/04/2013 11:29:08

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

RMAN> thanks

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

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

On 4 October 2013 05:36, De DBA <dedba_at_tpg.com.au> wrote:

> Hi,
>
> I've never seen this happen, but it looks to me that the connection that
> fails is not to the catalog. I read it as RMAN is trying to connect to the
> primary in order to resync the catalog, and that name (the primary) does
> not resolve. Did you check that tnsnames.ora on the machine/home that you
> are running RMAN from has an entry for the primary? The tns alias should be
> the same as what is defined in log_archive_config on the standby, I imagine.
>
> Cheers,
> Tony
>
> On 02/10/13 20:30, Outsider wrote:
>
>> 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.
>>
>>
>> <snip>
>
>

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

Received on Fri Oct 04 2013 - 11:40:44 CEST