Assume I've cloned PROD database to TEST with RMAN "duplicate target database to CLONE from active database;". After several days I need to refresh CLONE. Will RMAN transfer all the datafiles from PROD to CLONE or only datafiles with changed data if I will issue "duplicate from active database again" ?
Oracle 11gR2, duplicating and refreshing cloned database
duplicationoraclerman
Related Question
- Oracle Database – How to Move to a New Server
- Duplicate database leaves orphan archivelog files
- Oracle – Duplicate Schema to Another Database
- How to prevent an oracle block corruption from duplicating a database with a few nologging tables
- Oracle Migration – Online Database Migration to Different Oracle Release
- Problems with connecting to a remote Oracle 12c database
- Oracle RMAN Duplication – Fix Syntax Errors RMAN-01009, RMAN-01008, RMAN-01007
- Oracle 12cR1 – Duplicate Database Without Resetlogs
Best Answer
It will transfer all datafiles again.
The previous duplicate already changed all your datafiles. You have a new database incarnation, with a new name, a new dbid, which was written in the datafile headers.
RMAN duplicate skips existing datafiles in case of re-running a failed duplicate so it does not perform the same work again, but that is a different use case.