Re: RMAN Skip Tablespaces
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>, ax.mount@xxxxxxxxx
- Date: Fri, 12 Dec 2008 09:57:43 +0000 (GMT)
Hi
You will also encounter some errors as RMAN drops the tablespaces in a reverse
sorted list of tablespace names.
You’ll get errors if you try to exclude tablespaces that contain indexes
used for enforcing unique or primary keys.
I also notice that you are planning to exclude LOB tablespaces i am not 100%
sure but i think you are not going to suceed trying to duplicate the database
by excluding the LOB tablespace
regards
Hrishy
--- On Fri, 12/12/08, hrishy <hrishys@xxxxxxxxxxx> wrote:
> From: hrishy <hrishys@xxxxxxxxxxx>
> Subject: Re: RMAN Skip Tablespaces
> To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>, ax.mount@xxxxxxxxx
> Date: Friday, 12 December, 2008, 9:44 AM
> Hi
>
> We have done this a couple of times in 9i and 10g.
> In 9i we had problems with rman while restoring as we
> needed to do some steps manually (rman order of dropping
> tablespaces did not work) we had to drop the index
> tablespaces first or some such thing.
>
> 10g it worked version 10.2.0.3
>
> regards
> Hrishy
>
>
> --- On Thu, 11/12/08, amonte <ax.mount@xxxxxxxxx>
> wrote:
>
> > From: amonte <ax.mount@xxxxxxxxx>
> > Subject: RMAN Skip Tablespaces
> > To: "oracle-l"
> <oracle-l@xxxxxxxxxxxxx>
> > Date: Thursday, 11 December, 2008, 9:05 PM
> > Hi
> >
> > I have a 2TB database running in 10.2.0.2 Linux x64 2
> nodes
> > RAC.
> >
> > I have to refresh test environment with production
> > regularly. Since this
> > database contains 1.5TB LOB data in their own
> tablespaces
> > and they are not
> > requiered in the test environment, I have thought of
> using
> > RMAN duplicate
> > and skip these lob data tablespaces so I only need to
> > restore 500GB instead
> > of 2TB.
> >
> > Do you know if there are any issues by doing so?
> >
> >
> > TIA
> >
> > Alex
--
//www.freelists.org/webpage/oracle-l
Other related posts:
