RE: RMAN and Data Guard

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 6 Nov 2007 21:18:44 -0700
Message-ID: <KEEDIPJOJLCHPPAIDPDOIENGEHAA.robertgfreeman@yahoo.com>

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.

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

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Tue Nov 06 2007 - 22:18:44 CST