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@xxxxxxxx> wrote: > > > > ------------------------------ > > *From:* Prasad [mailto:p4cldba@xxxxxxxxx] > *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 > > >