Martins Blog

Powered by
WordPress

  • RAC 12c enhancements: adding an additional SCAN-part 2

    In the first part of this article you could read how to add an additional network resource, additional VIPs and SCAN to an 12.1.0.1.2 cluster. In this part I hope to show you the next steps such as adding the SCAN listeners and other resources. New SCAN listener With the second SCAN added it is…

  • RAC 12c enhancements: adding an additional SCAN-part 1

    Based on customer request Oracle has added the functionality to add a second SCAN, completely independent of the SCAN defined/created during the cluster creation. Why would you want to use this feature? A few reasons that spring to mind are: Consolidation: customers insist on using a different network Separate network for Data Guard traffic To…

  • How important is a Disaster Recovery site for you?

    I regularly read threads on the oracle-l mailing list, and occasionally feel very tempted to reply to one. Just recently I saw one that I liked a lot. It is specifically about using an Oracle Database Appliance (ODA) as a Disaster Recovery (DR) solution for an Exadata system. The Exadata configuration was not specified, I…

  • Duplicate from the standby instead from the primary in 12c

    This post is related to 12c and an active database duplication for a standby I did in my lab environment. I’d say although I first encountered it on 12c there is a chance you run into a similar situation with earlier releases too. I would normally use ASM for all my databases to make my…

  • Recovering a standby over the network in 12c

    Another one of the cool but underrated features in 12c is the possibility to recover a physical standby over the network with one line in RMAN. Why do you need to perform this activity? Assume someone really clever created a segment “nologging” and the database was not in force logging mode. This operation cannot be…

  • Interesting GNS anomaly in 12.1.0.1.2 RAC

    I was encountering an interesting anomaly with my 12.1.0.1.2 RAC cluster based on Grid Naming System. I have written about the setup here. No need to get back to the post-instead let me give you some background if you are not familiar with the Grid Naming System in RAC. Most RAC installations use a Domain…

  • Runtime Load Balancing Advisory in RAC 12c-addendum

    A reader asked an interesting question yesterday with regards to the previous post on the subject: where did you get your service metrics from when you queried v$servicemetric-PDB or CDB$ROOT? I queried the PDB, but this morning repeated the test to make sure the results are consistent, and they are. This is definitely something you’d…

  • Runtime Load Balancing Advisory in RAC 12c

    This is a follow-up on yesterday’s post about services in the new 12c database architecture. After having worked out everything I needed to know about TAF and RAC 12c in CDBs I wanted to check how FCF works with PDBs today. While investigating I found out that the Runtime Load Balancing Advisory does not seem…

  • RAC and Pluggable Databases

    In preparation of the OUGN Spring Seminar and to finally fulfill at least a part of my promise from July I was getting ready to research RAC, PDBs and services for my demos. It turned out to become a lot more interesting than I first assumed. RAC and Multi-Tenancy So the first attempt to really…

  • Public appearances first half of 2014

    I had the great fortune to have had many of my abstract accepted for upcoming conferences and other public appearances, the first ones for this year are these: OUG Ireland The first conference I’ll be attending is in Dublin, for OUG Ireland 2014 on March 11.I’m going to help out with RAC Attack and also…