Skip to content

duplicate

Reduce downtime when refreshing your non-production databases using Multitenant

Introduction You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback is the unavailability of the database being refreshed during the DUPLICATE. You first need to remove the old version of the… 

Documentum – How to easily remove duplicated xPlore queue items

Documentum is usually working pretty well with xPlore when it’s about managing its queue on well configured environments and/or with “simple” repositories. Basically, as long as you do not only have very big/complex documents (e.g.: 500Mb excel files with hundreds of thousands of rows) or a lot of customizations that aren’t very optimized or intensive components like a full Life… 

Documentum Upgrade – Duplicate JMS and ACS config objects

I have seen several times in the past duplicate JMS and/or ACS objects created by OpenText (and Dell/EMC before) installers. I opened several tickets with the OpenText Support over the past 4/5 years to try to get a reason and a fix (had the issue with all versions, 7.1, 7.2, 7.3, 16.4). The first few tickets (2 or 3, I… 

ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4

To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was that of course the source database was in Non-OMF while ODA works fully in OMF. The second was that the… 

RMAN 12c Push and Pull duplicate explained

By Franck Pachot . Oracle Database 12c introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can do all the job. Let’s… 

Oracle 12c duplicate in cluster fails with ORA-65500

I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some changes in the way RMAN makes the duplicate in 12c and cluster resources management. Basically up to 12c when RMAN… 

“ORA-01665: control file is not a standby control file”: what can I do?

You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the “Restore Failover”. In order…