Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN and Data Guard
Probably because the rman records are saved to the control file, even if you
are using a recovery catalog. I suppose this results in some recursive SQL
which finds it's way into the redo stream which is then replicated to the
stand-by database where it is replicated and finds it's way to the control
file. I don't have a configuration to test this theory, but I suspect that
may be the cause.
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
BLOG: http://robertgfreeman.blogspot.com/
Sig V1.2
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Randy Julien
Sent: Tuesday, November 06, 2007 1:17 PM
To: oracle-l_at_freelists.org
Subject: RMAN and Data Guard
I set up a 10.2.0.3 primary and physical standby database pair and configured each to use RMAN "incremental backups" with the Flash Recovery Area (FRA). I then registered each database to separate RMAN recovery catalogs, performed a full "incremental save" of the primary to the FRA followed by a BACKUP RECOVERY AREA taking the FRA contents to tape. I was then able to connect to the RC of the standby from the standby and view the save of the primary via RMAN "list" commands. How is this possible with separate RCs and controlfiles? This configuration mirrors Oracle's "Geographically Too Distant" scenario from the DG Admin Guide (chapter 10), which I may face. Note that I did use the backup with a TAG identifying the database TNS alias the save originated from. Can anyone shed some light on this.
Thanks!!
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 06 2007 - 22:18:44 CST