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