Migrating from Windows to Linux with Active Duplicate for standby – problem with

Recently I was working on migrating Oracle database running on Windows, to new hardware infrastructure on Linux. This Oracle version is with us for quite a long time, plus migration from Windows to Linux is quite common (fortunately in that direction…;)), so when I got an error while trying to use Active Duplicate feature to create a standby database, I was quite sure I’ll be able to quickly find the solution either in MOS or elsewhere. Indeed, I found several blog posts with exactly the same error, but solution mentioned there was not working for me.

Continue reading “Migrating from Windows to Linux with Active Duplicate for standby – problem with”


Backups in Data Guard environment

Originally posted on “Databases at CERN” blog

Physical standby databases seem to be ideal candidates for offloading backups from primary ones. Instead of “wasting” resources (unless you’re already using Active Data Guard for example), you could avoid affecting primary performance while backing up your database, especially if your storage is under heavy load even during normal (user- or application-generated) workload. So, if you’re seeking for good reasons to convince your boss/finance department/etc. that having standby database(s) is a must in your environment, ability to offload backups from primary databases would be for sure important (apart from usual ones, related to disaster recovery, etc.).

Continue reading “Backups in Data Guard environment”