Duplicating an Oracle RAC 19c to a Single Oracle Data Guard 19c

Due to some questions I had while creating a physical Oracle Data Guard in an environment where the primary is a RAC environment and the standby is a single-node environment, both multitenant, I decided to write this article. Check the environment information: HOSTNAME ORACLE VERSION OPERACIONAL SYSTEM ROLE orarac01 19.3.0.0 Oracle Linux 7.9 PRIMARY orarac02 … Mais Duplicating an Oracle RAC 19c to a Single Oracle Data Guard 19c

Error ORA-14404: partitioned table contains partitions in a different tablespace During Duplicate Database With Tablespace Parameter

Last week I got an issue trying to duplicate a database with only READ WRITE tablespaces for a specific table that had many partitions, some of them READ ONLY and others, those I wanted, READ WRITE. The goal for this operation is save time in a disaster event. Unfortunately, using SKIP READONLY command parameter was … Mais Error ORA-14404: partitioned table contains partitions in a different tablespace During Duplicate Database With Tablespace Parameter