This content has been marked as final. Show 2 replies
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.
Backup RO tablespaces only once:
backup as compressed backupset incr
emental level 0 diskratio=0 tag
filesperset 5 tablespace
Use RMAN Level 0 and Level 1 Compressed skip RO to backup database:
backup as compressed backupset incremental
level 0 skip readonly diskratio=0 tag
ilesperset 5 (database) ;
Restore the database first
RMAN restore database/switch datafile all;
Restore RO tablespaces ahead of time and RMAN catalog/switch afterward
In a RAC environment, shutdown other ASM instances during restore
Do not restore mutilple RO tablespaces concurrently
Do allocate multiple RMAN channels