Re: RMAN duplicate and read-only tablespaces

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"