Oracle VM Consulting
view counter

Feed items

Migrating an Oracle Home – dead easy?

Changing a database to use a new oracle home is easy isn’t it? A simple interview question that you would never get wrong. Everyone knows that you shutdown the database , edit the oratab file and restart the database again.  So then the interviewer presses and is obviously looking for more.

You confidently follow-up with ‘of course I would have copied the passwd and the init.ora file to the new ORACLE_HOME/dbs folder during the outage.’ The interviewer says “go on, what else will you do?”.

Speeding up datapump exports in 11.1.0.7

I noticed that a small datapump export  involving a few tables was taking more than 30 minutes. I tried enabling parallelism, which was a mistake as for small tables parallelism is not utilised even if the parameter is used in the parameter file – that is probably worth a blog in itself. I then assumed it was a disk performance issue until I tried it on other systems and realised it was quite a general thing.

I then came across bug 10153617  which is quite old (Sept 2010) but the 11.1.0.7  release is old now as well.

Rebuild of standby using incremental backup of primary

I have a long to-do list of things I want to test out and one is rebuilding a standby by using an incremental backup from primary. Then along comes a note from my ex-colleague Vitaly Kaminsky  who had  recently been faced with the problem when a customer relocated two Primary 2-node RACs and a single node standby databases to a new location and just happened to start the standby databases in read-only mode. Vitaly tells the story :-

database user xs$null

When we put a new system into production we get the whole set of infrastructure penetration tested. Reading a recent review I saw the following recommendation as part of the database section.

UKOUG Database Server SIG in Leeds, May 9th 2013

Last time a database server SIG was held in Leeds we had a very good attendance and hopefully this will be repeated on Thursday May 9th 2013 when the Metropole Hotel will be the host. This 4 star hotel is very conveniently placed not more than a couple of hundred yards from the station and should be a very good venue.

As always we are looking for good presentations from UKOUG members so that we can have a really strong database focused agenda.

Adding new ASM disks – what is best practise?

According to My Oracle Support note – “How To Add a New Disk(s) to An Existing Diskgroup on RAC (Best Practices). [ID 557348.1]” you should create a test diskgroup using new storage before adding it to an existing diskgroup. That seems eminently sensible, although it is not something I normally do. It proves you can access the disk, and if there is a conflict (i.e the disk is already mapped and in use elsewhere) you are not risking your production DATA diskgroup.

How to identify if a patch is available within a PSU

Within MoS there are a set of notes which list all the patches of each PSU and show in which PSU they came in (PSUs are cumulative). The READme.html file with each PSU does not contain this information

11.1.0.7 Patch Set Updates – List Of Fixes In Each PSU [ID 1337836.1]
11.2.0.1 Patch Set Updates – List Of Fixes In Each PSU [ID 1340010.1]
11.2.0.2 Patch Set Updates – List Of Fixes In Each PSU [ID 1340011.1]
11.2.0.3 Patch Set Updates – List Of Fixes In Each PSU [ID 1449750.1] 

Me and my Exadata Xmas present

Actually it is a cardboard cutout – not me, the server. We have real ones downstairs in the data centre but my cardboard one doesn’t cost as much to support or keep air-conditioned.

Merry Xmas to all

IMG_0896

UKOUG 2012 – Day 3

Today was Unconference day at UKOUG which was a pot-pourri of talks all lasting about 20 minutes each. The talks were interesting although sparsely attended, which was actually a benefit as there was plenty of opportunity for interaction and indeed complete disregard of the main topic under discussion.

I didn’t actually get to see any scheduled presentations but I had seen enough in the previous two days to keep me going for a while.

So adios UKOUG at Birmingham and welcome to the Tech conference in Manchester next December.

UKOUG 2012 – Day 2

A deep dive into Dataguard is a tough way to start the day off but Emre Baransel handled it well. I jotted down about 6 or 7 takeaways for later investigation. Much of the talk was about tuning the redo log apply and I must admit that I don’t consider we have many problems in that area across the estate but it is still worth reviewing. One topic that stuck me as looking at in more detail was the ability to recover a standby database from a primary backup. Chatting to a few people afterwards they had all heard of the capability to do that but had never tested it.

view counter