user11188564 wrote:Here i got some information for you, Check page no 12 of http://www.oracle.com/au/products/database/s281211-fnf-132193.pdf
I have a backup(image copy) of the primrary database that is a day behind - Take a full image copy on Day 1 and merge with the daily incremental backup (using the block change tracking). In the primary database I have a few partitioned tables - partitioned by date. Every day the partitions which are more than a week old are marked as READ ONLY.
I would like to clone the standby database using this backup - copy only the R/W tablespaces (i.e. not copy the READ only partitions) , restore the standby and start the replication. The copy and restore of the READ only partitions is deferred till the replication is started - to minimize the loss.
Are there any potential problems with this approach. If the steps are available I will really appreciate that.