Oracle Database Discussions

step wise documents

for example as shown below:-


Server control Utility commands to manage the RAC Instances:
***********************************************************
Start a rac database
Order should be
1) Nodeapps
2) ASM
3) Database
srvctl start nodeapps -n nodename
srvctl start asm -n nodename
srvctl start database -d dbname

Stop a rac database
Order should be
1) Database
2) ASM
3) Nodeapps
srvctl stop database -d dbname -o immediate
srvctl stop asm -n nodename
srvctl stop nodeapps -n nodename
To check status and configurations

Nodeapps:
srvctl status nodeapps -n nodename
srvctl config nodeapps -n nodename
ASM:
srvctl status asm -n nodename
srvctl config asm -n nodename
Database:
srvctl status database -d dbname
srvctl config database -d dbname (shows instances name, node and oracle home)
Instance:
srvctl status instance -d dbname -i instancename
Services:
srvctl status service -d dbname
To start and stop instances
srvctl start instance -d dbname -i instancename
srvctl stop instance -d dbname -i instancename
To start, stop and manage services

srvctl status service -d dbname
srvctl config service -d dbname
srvctl start service -d dbname -s servicename
srvctl stop service -d dbname -s servicename

CRS Control utility commands
********************************
To check how many nodes in the cluster
Olsnodes -n
To show the resource status
crs_stat –t
To check the daemon status
ps -ef|grep d.bin
To check CSS,CRS & EVM healthy status
Crsctl check crs
Crsctl check css
Crsctl check evm
To stop the CRS and all other services
Crsctl stop crs

To enable the crs fromstarting on reboot
Crsctl enable crs*
To stop all the registered resources
Crs_stop –all
To start all the registered resources
Crs_start –all


To check what are the diskgroups are available use the below query

sql> select name, total_mb, free_mb from v$asm_diskgroup;

To find the free asm disks available use the below query

sql> select path from v$asm_disk where header_status in (’FORMER’ , 'PROVISIONED');

Once you identified the free disk use the below command to add the disk to the diskgroup

sql> Alter diskgroup diskgroup_name add disk 'disk_name';


To create the tablespace use the below sql statements

sql> create tablespace tablespace_name datafile 'diskgroup_name' size 99m next 100m maxsize 25600m;

To alter the tablespace use below sql statements

sql> alter tablespace tablespace_name add datafile 'diskgroup_name' size 99m next 100m maxsize 25600m;

sql> alter database datafile 'diskgroup_name' autoextend on maxsize 51200m;

similar kind of queries and step wise ,document for each scenario.


mointoring steps in rac..................etc...............any documents related to rac.recovery,performance tuning,dataguard,asm or any document related to dba.............


many thanks in advance

cheers friends