RE: Standby abuse

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Mon, 10 Nov 2008 13:45:08 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F1FA1BABC@US-BOS-MX011.na.pxl.int>

Dominic,  

    Well, you might be able to off load your backups to your logical standby if your backup method was export/import or Data Pump. But for a rman or tape backup you could not because those items are referenced elsewhere in the database and if they got out of sync your in serious trouble. As in an index entry would be pointing to a bad rowid.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  

---

From: ddelmoli_at_gmail.com [mailto:ddelmoli_at_gmail.com] On Behalf Of Dominic Delmolino
Sent: Friday, November 07, 2008 5:52 PM
To: Goulet, Richard
Cc: Oracle-L Freelists
Subject: Re: Standby abuse

Dick,

I'd argue that I could definitely off-load my backup needs if I only cared about the data, and not so much of the physical aspects of how it's laid out. I generally don't like to use ROWIDs as data values since they can change, and I can't think of a reason why I'd care if the object id's were different -- can you give me an example?

On Fri, Nov 7, 2008 at 4:10 PM, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:

        Dominic,          

            You can't use a logical standby to off load your backup needs. This is because a logical does not replicate the original database, but only the transactions therein. Rowid's and object id's between the two will be different so you can't just move a data file from your logical standby to the primary for recovery purposes. A physical standby is the only way to do that since it does maintain rowid's and the like.          

	Dick Goulet 
	Senior Oracle DBA 
	PAREXEL International 
	978.313.3426 
	 information transmitted in this communication is intended only

for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.          

---

-- 
Dominic Delmolino


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

Received on Mon Nov 10 2008 - 12:45:08 CST