RE: rman online backup with exclude undo tablespace

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Fri, 18 Jan 2008 15:35:02 -0500
Message-ID: <21469B88E0EA11498818517F2103353101C65D4D@EPRI17P32001A.csfb.cs-group.com>

I have to agree with Mark's previous comment. You are straying pretty far afield from the reason you undertook this exercise in the first place and expending effort that's better directed toward performing an appropriate test. Undo segments underlie just about everything Oracle does and I think it unwise to try to test anything without them. You would have a hard time convincing anyone that the results of such tests would predict the behavior of an actual database restore and recover.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prasad Sent: Friday, January 18, 2008 2:32 PM
To: Mark W. Farnham
Cc: oracle-l
Subject: Re: rman online backup with exclude undo tablespace

Hi Mark,

Here in this client if we do not want to copy over network then normally somebody goes to the datacenter in person and copy it to a usb and bring it back. We were thinking that we might be lucky to deal with this exclude ts backup but it is not going smooth so far.

thanks
-Prasad

On Jan 18, 2008 10:58 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:                             

---

	From: Prasad [mailto:p4cldba_at_gmail.com] 
	Sent: Friday, January 18, 2008 1:09 PM
	To: Mark W. Farnham
	Cc: oracle-l
	Subject: Re: rman online backup with exclude undo tablespace

	 

	
	we are trying to build a test system and we took the rman online

backup using exclude undo tablespace as the undo tablespace is very big (16G) and transferring between production and test network is very slow .         

        I am trying to force start the db so that I can do a expdp and recreate the db however I am facing difficulty while setting the
_corrupted_rollback_segments
        

        Is there a limitation on the length for setting the
_CORRUPTED_ROLLBACK_SEGMENTS
                          <snip>         

        There was last time I checked, which is indeed an interesting problem for dealing with automatic undo in the case where one must actually resort to _corrupted_rollback_segments, since the list can get very long.

        But aside from that, what you are attempting to do seems quite unwise to me. Is a network the only available means to get data from the production system to the test system? Even if you succeed with getting your test database to a place where you can export the contents, I would regard the relational integrity of the results as suspect and not worthy against which to run tests.          

        Regards,          

        mwf          

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

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

Received on Fri Jan 18 2008 - 14:35:02 CST