Martins Blog

Powered by
WordPress

  • 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…

  • Data Guard transport lag in OEM 12c

    I have come across this phenomenon a couple of times now so I thought it was worth writing up. Consider a scenario where you get an alert because your standby database has an apply lag. The alert is generated by OEM and when you log in and check-it has indeed an apply lag. Even worse,…

  • Massive tablespace fragmentation on LMT with ASSM

    I have been asked to investigate another interesting problem worth writing about. It’s worth mentioning here because it deals with a problem I believed to have long since been solved: tablespace fragmentation. However, in this case it was a locally managed tablespace (LMT) with Automatic Segment Space Management (ASSM) enabled. It should be difficult to…

  • Applying GI PSU 12.1.0.1.2 in the lab

    In my previous posts about the first RAC Grid Infrastructure Patchset I document a few issues I encountered that were worth noting. But where things work as advertised I am more than happy to document it too. In a way, the January 2014 GI PSU works as you’d hope it would (at least in my…

  • Applying PSU 12.1.0.1.1 to Oracle Restart

    I was actually hoping I had already written enough about applying the PSU for 12.1.0.1.0 but today I tried to apply the patch to my Oracle Restart home in my lab VM and guess what-it wasn’t as automatic as I thought. I must have performed the classic copy & paste error and applied the patch…