Ardent Performance Computing
Technical
Doug Burns on Oracle User Groups
Just read Doug Burns’ interview from the Autumn 07 edition of AUSOUG‘s Foresight magazine. It’s a fun read; Doug talks about how he got into technology and Oracle, the strengths and weaknesses of the Oracle RDBMS, and his addiction to the command line. But the part that jumped out at me the most was his … Continue reading
Chicago Oracle Users Group Meeting
So we just had the spring COUG meeting. Two speakers this time, Charlie Garry from Oracle and Dean Richards from Confio. Oracle volunteered a meeting room; their offices are in the Sears Tower downtown. They also provided food. (Very cool!) Toward the end – after 5 or 6 people took off – I counted 24 … Continue reading
Controlfile Recovery WITHOUT Resetlogs
Well last week I had a few posts about controlfile recovery; one about recovering without a backup and one about recovering with a backup using RESETLOGS. In the second post I showed how when you restore a backup controlfile Oracle will always require you to recover then open the database with RESETLOGS. Hemant Chitale pointed … Continue reading
Redo Log Filename Extension
I have to say that I really like the oracle-l mailing list. It tends to stay pretty focused on DBA stuff, there’s a low volume of spam and there are a lot of really smart guys who post there. I was just catching up on some threads from last week and a comment about how … Continue reading
Fidelity Case Study
So I guess this is old news since they finished this implementation back in June last year and even presented at Open World. But this case study is just a goldmine of information and totally worth reviewing if you’re anywhere close to RAC, Data Guard, ASM, RMAN, or Flashback (and more I’m sure). The big … Continue reading
Controlfile Recovery Requires RESETLOGS
In response to a small discussion on the oracle-l mailing list last week I thought I’d put together a quick demo of exactly what I was referring to in my email. Basically I was discussing how even when you do a normal shutdown – leaving your database in a consistent state that doesn’t require recovery … Continue reading
Recovering Your Controlfile Without a Backup
Little trick I’d seen once that might come in handy for someone. Lets suppose that somehow you accidentally delete (“rm”) all copies of your current controlfile – and you don’t have a backup!! If the database is still running then don’t shut it down! There might actually be a way to recover the control file. … Continue reading
Who’s Accessing That File?
From the occasionally-useful-scripts library… It’s like fuser but shows name of the process (args[0]). Needs lsof installed. I’ve used it on Linux and Solaris. nap01:~$ cat jduser #!/bin/sh [ -n “$1” ] && [ -d “$1” ] || { echo “Usage: $0 [dir]”; exit; } AWK=awk; [ “`uname`” = “SunOS” ] && AWK=nawk; lsof +d … Continue reading
The Clusterware C API
Well I’ve been incognito for the past two weeks or so because I’ve been finishing up a pretty detailed paper about Oracle Services. Finally finished up the first draft yesterday… it’s 16 pages in the IEEE Computer Society article LaTeX class – which doesn’t leave much whitespace! It’s a pretty comprehensive review of pretty much … Continue reading
Migrating to RAC/ASM with RConfig
That 11i/RAC/ASM project turned out to be fairly interesting for quite a few reasons – another reason was that it gave me an opportunity to become quite a bit more familiar with RConfig. RConfig an Oracle provided java-based utility to fully automate the process of converting a database from single-instance to RAC. It will also … Continue reading
Disclaimer
This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.
contact: schneider @ ardentperf.com
Ardent Performance Computing 
Recent Comments