Re: rman online backup with exclude undo tablespace
Date: Fri, 18 Jan 2008 12:51:39 -0800
Message-ID: <bf46380801181251u28bdb18ar4b9e7d56c4fd4c18@mail.gmail.com>
On Jan 18, 2008 10:09 AM, Prasad <p4cldba_at_gmail.com> wrote:
> 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 .
>
If the UNDO is not included, there is little point in making a backup.
>
> 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
>
> This below works
>
> ...it do not show me in show parameters.
>
> any way to deal with this?
>
>
Yes, open a support ticket with Oracle.
There are some other 'tricks' involved in using _corrupted_rollback_segments.
Please don't ask me how to do it either, you need to open a support ticket.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 18 2008 - 14:51:39 CST