An "enhancement" in 11.2 prevents RMAN duplicating non self-contained subset of a database
Oracle 11gR2 has introduced a quite annoying "enhancement" of RMAN duplicate (http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/wnbradv.htm#CHDBCFEB) - it's performing some validations:
(1) preventing duplication (from active database) of a subset of partitions of partitioned table;
(2) and also breaks duplicating a tablespace which contains database audit trail table (FGA_LOG$) if it has been moved out of SYSTEM tablespace
... and some other cases
This makes our life a nightmare since we used to create a test databases out of large production one containing just the recent partitions (residing in separate tablespaces) of range-partitioned tables... But now that doesn't work anymore :-(
(1) preventing duplication (from active database) of a subset of partitions of partitioned table;
(2) and also breaks duplicating a tablespace which contains database audit trail table (FGA_LOG$) if it has been moved out of SYSTEM tablespace
... and some other cases
This makes our life a nightmare since we used to create a test databases out of large production one containing just the recent partitions (residing in separate tablespaces) of range-partitioned tables... But now that doesn't work anymore :-(
1