Monthly Archives: August 2010

How to create a Oracle Database on LVM

SUSE Linux Enterprise Server 10 (x86_64) VERSION = 10 PATCHLEVEL = 2 What LVM offers? LVM is a way to club two or more hard drives into a logical space which can be easily resized (unlike partitions). So to implement … Continue reading

Posted in Oracle Database Creation Assistant | Tagged , | Leave a comment

How to create a Oracle Database on RAW devices

SUSE Linux Enterprise Server 10 (x86_64) VERSION = 10 PATCHLEVEL = 2 Some of the commands I’ve mentioned here are specific to SUSE and may not work on other Linux operating systems like RedHat. STEP 1 ====== Select the disk(s) … Continue reading

Posted in Oracle Database Creation Assistant | Tagged , | 1 Comment

How to monitor transaction Rollback Progress

Suppose we execute a huge update or delete operation on a table & issued a kill statement. What happens?  Session does not terminate immediately. It is marked for kill and the rollback is done in the background. SQL> ALTER SYSTEM … Continue reading

Posted in Oracle Database Architecture | Tagged | Leave a comment

Automated Oracle Install

Normally building the database servers requires installing the required operating system, installing the oracle database binaries setup the required environment etc. Normally it becomes a routine time consuming task. There are platform specific options available to reduce these efforts.  For … Continue reading

Posted in Oracle Software Install / Deinstall, Oracle Software Inventory | Tagged | Leave a comment

Cloning Oracle ASM Database with KFED

There could be a requirement to create frequent clone of the databases for doing some kind of testing. There are multiple options for cloning, for example: use physical backup, logical backup (conventional export or datapump), CTAS (create table as select). Let’s … Continue reading

Posted in Oracle Automatic Storage Management, Oracle Database Cloning | Tagged | 6 Comments

Recovering lost OCR & Voting disk in 11gR2

Recovering Lost OCR & Voting disk in 11gR2 If we lost both OCR & voting disks, we can recover then using following steps. Actually it is pretty straight forward. We need to run root.sh (after  rootcrs.pl -deconfig) on all the … Continue reading

Posted in Oracle Cluster Ready Services, Oracle Real Application Cluster | Tagged | Leave a comment

Recovering lost OCR & Voting disk in 11gR1

I’ve recently faced this problem. In one of my test environment, some of the disks on which my OCR & voting disks were placed corrupted. I also didn’t had the backup of any of those. Normally this situation shouldn’t arise, … Continue reading

Posted in Oracle Cluster Ready Services, Oracle Real Application Cluster | Tagged | 1 Comment