Re: rman online backup with exclude undo tablespace

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: "Mark W. Farnham" <mwf@xxxxxxxx>
  • Date: Fri, 18 Jan 2008 11:32:12 -0800

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

Other related posts: