This discussion is archived
9 Replies Latest reply: Oct 3, 2013 7:05 PM by Hemant K Chitale RSS

Oracle Standby and RAMN CATALOG

__OUTSIDER___ Newbie
Currently Being Moderated


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

 

 

 

 

 

 

 

 

 

 

 

 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points