The Goldengate INSERTALLRECORDS commands can be used in cases where the requirement is to have on the target database a transaction history or change data capture (CDC) tables which will keep a track of changes a table undergoes at the row level.
So every INSERT, UPDATE or DELETE statement on the source tables is captured as INSERT statements on the target database
But in certain cases update statements issued on the source database can cause the replicat process to abend with an error:
The goal of this blog is to to easily explain an efficient way of moving ASM to new Disks. Every now and then we need to come up with a way to move to new hardware, especially when Disks are created with external redundancy. New disks are required to come in, and old disk need to be phased out.
Exadata is a powerful machine with lots of resources, where you can consolidate lots of databases. It is a pleasure to create many databases when you have 750 TB of storage and 2 TB of RAM across 8 nodes. You can use half the nodes to create some Standby Databases, use only 2 nodes to create some test databases, use 8 nodes for more important databases, move some services to other nodes before performing a maintenance, etc. It is a wonderful place to have fun and come up with lots of ideas!
I have recently taken over our Systems Management team and we have several vacancies for people used to working with the HP toolset. I know my blog is read almost entirely by DBAs but I am sure some of you work with Systems management teams and hopefully you can pass a link on to anyone you think might be interested.
A while ago, I posted
href="https://www.pythian.com/blog/amcmd-better-du/">a better “du” for asmcmd . Since then, Oracle 12cR2 beta has been released but it seems that our poor old “du” will not be improved.
I then wrote a better “better du for asmcmd” with some cool new features compared to the previous one which was quite primitive.
Oracle introduced the ODA X6-2S and ODA X6-2M. And no, they are not the successor of the quite popular ODA X5-2, which we installed and configured quite a number of times lately. These 2 new machines are the in-between ODA’s, entry level machines for small business. Single node with flash storage, also suitable for Oracle Database Standard Edition 2. But…. commodity hardware is also single node and suitable for all Oracle database Editions, so what’s the gap Oracle is filling between commodity hardware and an ODA X5-2?