Re: RMAN duplicate and read-only tablespaces

I agree. But I find that most times, when Oracle doesn't work as you'd expect it to, it gets fixed in a later version. And sometimes, it gets fixed in a later version then they initially say it is fixed in.

Cheers,
Brian

Keith wrote:
>
> Good idea -- I'll probably have to break down and do just that.
>
> However, for the amount of money we pay for the product there's an
> expectation that it works as described. If it doesn't, I have an
> expectation the vendor will fix or at least document the problem. I
> shouldn't be told to call back and open a new case to do just that --
> especially since they cannot provide any verbiage as to why it's
> unsupported.
>
> Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F27D25B.36E1201C_at_remove_spam.peasland.com>...
> > I'm not quite sure that this is the answer that you are looking
> > for....but if you can't duplicate the READ ONLY tablespace, why not just
> > use Transportable Tablespaces to move just that tablespace? Use RMAN to
> > duplicate the rest.
> >
> > HTH,
> > Brian
> >
> > Keith wrote:
> > >
> > > Hello Gurus,
> > >
> > > I am curious if anyone has used "rman duplicate" to duplicate a
> > > database with read-only tablespaces?
> > >
> > > I recently tried this and I received:
> > > ORA-01152: file 30 was not restored from a sufficiently old backup
> > > ORA-01110: data file 30:
> > > '/opt/oradata03/psqa/data/ps_hr_hist_table01.dbf
> > >
> > > Oracle support has stated this is not supported. But nowhere in the
> > > Oracle RMAN Users Guide, nor the RMAN reference guide have I seen
> > > this. In fact, the docs state to use the "skip readonly" clause to
> > > omit these tablespaces from the duplication because they are included
> > > by default.
> > >
> > > The support engineer was unable to provide any documentation saying it
> > > was unsupported. He sent me a few bug reports that describe what I
> > > was seeing, but the reports said it was fixed in 817. My target db,
> > > aux db, and rman binary are 8174.
> > >
> > > Any help is much appreciated.
> > >
> > > Thanks,
> > >
> > > Keith
> >
> > --
> > ===================================================================
> >
> > Brian Peasland
> > dba_at_remove_spam.peasland.com
> >
> > Remove the "remove_spam." from the email address to email me.
> >
> >
> > "I can give it to you cheap, quick, and good. Now pick two out of
> > the three"

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"