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

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