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 [...]
Fidelity Case Study
May 10th, 2007 § 1 Response
Controlfile Recovery Requires RESETLOGS
May 9th, 2007 § 24 Responses
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 [...]
Recovering Your Controlfile Without a Backup
May 4th, 2007 § 7 Responses
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. [...]
Who’s Accessing That File?
May 3rd, 2007 § 2 Responses
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 [...]
The Clusterware C API
May 2nd, 2007 Comments Off
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 [...]