RMAN duplicate and read-only tablespaces

From: Keith <kknauss_at_yahoo.com>
Date: 29 Jul 2003 10:51:44 -0700
Message-ID: <4ddf7db5.0307290951.5295eddc@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 Tue Jul 29 2003 - 12:51:44 CDT