RE: rman online backup with exclude undo tablespace
Date: Fri, 18 Jan 2008 15:35:02 -0500
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.
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prasad Sent: Friday, January 18, 2008 2:32 PM
To: Mark W. Farnham
Subject: Re: rman online backup with exclude undo tablespace
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.
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 onlinebackup 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
Is there a limitation on the length for setting the
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.
Please access the attached hyperlink for an important electronic communications disclaimer:
Received on Fri Jan 18 2008 - 14:35:02 CST