Home » RDBMS Server » Backup & Recovery » Problem with RESYNC CATALOG FROM DB_UNIQUE_NAME ALL; (Oracle e 11.2.0.1.0 - Linux 5.9)
icon5.gif  Problem with RESYNC CATALOG FROM DB_UNIQUE_NAME ALL; [message #630636] Thu, 01 January 2015 08:25
ch.floreck
Messages: 1
Registered: January 2015
Location: Germany
Junior Member
Hi

I've setup a physical standby Datebase.
When I issue RESYNC CATALOG FROM DB_UNIQUE_NAME ALL; the local Database is synced.
The remote database however is not synced. No error message comes up.

Any one a idea?
Thanks a lot

Christian

DB01 is primary
DB02 is standby

on primary:
rman target sys/xx@DB01 catalog rman/rman@rman
RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
Vollständige Neusynchronisation des Recovery-Katalogs wird begonnen
Vollständige Neusynchronisation abgeschlossen
Resynchronisation aus Datenbank mit DB_UNIQUE_NAME DB02
RMAN-Ausgabe für Datenbank mit DB_UNIQUE_NAME DB02 nicht resynchronisiert <= DB02 (standby no resynced)
Vollständige Neusynchronisation abgeschlossen <= Resync has been completed.

on standby:
rman target sys/xx@DB02 catalog rman/rman@rman
RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
Resynchronisation aus Datenbank mit DB_UNIQUE_NAME DB01
Vollständige Neusynchronisation des Recovery-Katalogs wird begonnen
RMAN-Ausgabe für Datenbank mit DB_UNIQUE_NAME DB01 nicht resynchronisiert <= DB01 (primary, no resynced)
Vollständige Neusynchronisation abgeschlossen <= Resync has been completed.


On the remote Database each resync generates a trace file:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: LinuxDGN02.localdomain
Release: 2.6.39-400.215.15.el5uek
Version: #1 SMP Wed Dec 17 22:04:10 PST 2014
Machine: x86_64

Instance name: DB02
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 11367, image: oracle@LinuxDGN02.localdomain

*** 2014-12-30 15:43:47.397
*** SESSION ID:(21.67) 2014-12-30 15:43:47.397
*** CLIENT ID:() 2014-12-30 15:43:47.397
*** SERVICE NAME:() 2014-12-30 15:43:47.397
*** MODULE NAME:(oracle@LinuxDGN01.localdomain (TNS V1-V3)) 2014-12-30 15:43:47.397
*** ACTION NAME:() 2014-12-30 15:43:47.397

krbmsrvgrcf:Expected db_unique_name: DB02
krbmsrvgrcf:mydbuname = :DB02:
krbmsrvgrcf:Instance with connect id DB01 requested controlfile.
krbmsrvgrcf:Filespec: /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_DB01.f

*** 2014-12-30 15:43:47.730
krbmsrvgrcf:Transferred controlfile to instance


Previous Topic: ORA-00376: file 3 cannot be read at this time
Next Topic: Restore INCREMENTAL LEVEL 1 backup
Goto Forum:
  


Current Time: Wed Feb 21 06:29:07 CST 2018

Total time taken to generate the page: 0.01563 seconds