Re: RMAN duplicate and read-only tablespaces

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"
Received on Fri Aug 01 2003 - 08:59:05 CDT