My Daily Learnings about Oracle Technology

Step #0: Set up the Oracle Code Tree. cd $ORACLE_HOME/clone/bin perl clone.pl ORACLE_HOME="/u002/app/oracle/product/11.2.0/db_1" ORACLE_HOME_NAME="TST_ORACLE_HOME" ORACLE_SID="TST" ORACLE_BASE="/u002/app/oracle" inventory_loc=/u002/app/oracle/oraInventory inst_group=dba export ORACLE_HOME=/u002/app/oracle/product/11.2.0/db_1 export ORACLE_SID=uhcmtst export ORACLE_BASE=/u002/app/oracle export PATH=$PATH:$ORACLE_HOME/bin/. export PATH=$PATH:$ORACLE_HOME/OPatch/. /u008/app/oradata/uhcmtst/controlfiles /u008/app/oradata/uhcmtst/datafiles /u008/app/oradata/uhcmtst/redologfiles Ensure that you have a VALID cold backup. The cold backup mentioned here is obtained by using RMAN in mount mode on a 11g Database. Step #1: Restore the Control Files [oracle@dvpsaixdb02us] controlfiles $ rman target / Recovery Manager: Release 11.2.0.2.0 - Production on Wed Nov 8 07:00:47 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights...

Discussion about startup sequence and service features of Grid InfraStructure Services This is a three part series which discusses exhaustively about 11gR2 GRID Infrastructure Services. Assuming that we are discussing about a unix like operating system or a linux. Once the OS finishes the bootstrap process, it reads the /etc/initab file via the initialization daemon init.d At the end of the file "/etc/inittab" is a line, which looks something like this "h1:35:respawn:/etc/init.d/init.ohasd run > /dev/null 2>&1 </dev/null" the above line inidicates the initialization daemon to trigger the Oracle High Availability Services Daemon. OHASD is of two types - OHASD for cluster(also known as crs) - OHASD for non-rac environments(also known as has) ; has - high availability service Oracle Restart is bundled with GI software/Clusterware which is usually installed as part of non-rac environment installation OHASD starts 3 com...