Monthly Archives: November 2007

Restoring Database to Different ASM Disk Group Layout

Create a cold backup of source database, when database is in mount stage run {allocate channel oem_backup_disk1 type disk format ‘/%U’;allocate channel oem_backup_disk2 type disk format ‘/%U’;allocate channel oem_backup_disk3 type disk format ‘/%U’;allocate channel oem_backup_disk4 type disk format ‘/%U’;backup as … Continue reading

Posted in Oracle Automatic Storage Management, Oracle Database Backup, Oracle Recovery Manager | Tagged | Leave a comment

Preventing Automatic Instance Restart

When a node in RAC stops & re-start, oracle clusterware try to start the instance as soon as node starts. This may not be desirable, because instance start-up may fail, if system components on which instance depends are not ready … Continue reading

Posted in Oracle Real Application Cluster | Tagged | Leave a comment

Server side load balancing in RAC

Server side load balancing in RAC Add following setting in $ORACLE_HOME/network/admin/listener.ora file on each node PREFER_LEAST_LOADED_NODE_LISTENER_=OFF Set LOCAL & REMOTE listener parameter For example, if I have 3 node cluster local_listener parameter can be added as alter system set local_listener='(ADDRESS … Continue reading

Posted in Oracle Connectivity, Oracle Real Application Cluster | Tagged | 2 Comments

Voting Disk backup

When raw devices are used for storing the voting disks, backup on UNIX platform can be taken by dd command sample shell votebak.sh export ORACLE_HOME=/u01/app/oracle/product/10.2.0dumpfile=votedsk`date +%d%h%y`dd if=/dev/rdsk/vot1 of=$ORACLE_HOME/votebackup/$dumpfile.bak

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

SSH setup for Oracle RAC

Configuring SSH on Cluster Member Nodes To configure SSH, you must first create RSA and DSA keys on each cluster node, and then copy the keys from all cluster node members into an authorized keys file on each node. 1. … Continue reading

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

User and Groups needed for RAC install

Groups – 1) oinstall 2) dba 3) oper $ groupadd oinstall$ groupadd dba$ groupadd oper Users – 1) oracle 2) nobody $ useradd -u 200 -g oinstall -G dba oracle $ id nobody -> if does not exist then, $ … Continue reading

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