Friday, October 27, 2006

o oracle I hate you...

currently I'm working on two major things in my favorite monster, called oracle.

1. create a script which automatical duplicates a given database each night on another server.

2. optimize the concurrency of the cluster to avoid row locks and table locks.


Problem number 1 took me only 8h of bash scripting and reading oracle books. I finally put it all together and tested it with a couple of backups.
You can find the result under: script

Basically it allows you to create a backup of your database using rman.

Problem number 2...

...working on it Posted by Picasa