Using rman to backup the datafile
'/opt/oradata03/psqa/data/ps_hr_hist_table01.dbf' first before you start the
rman duplicate.
This will resolve the problem.
"Keith" <kknauss_at_yahoo.com>
??????:4ddf7db5.0307290951.5295eddc_at_posting.google.com...
> 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
Received on Wed Jul 30 2003 - 00:50:52 CDT
