Identify ASM disk to physical disk

Identify ASM disk on ASM instance :

SQL>

select  g.name disk_group
       ,d.DISK_NUMBER
       ,d.name disk_name
       ,d.PATH
       ,d.TOTAL_MB
       ,d.header_status
from   v$asm_disk d,
       v$asm_diskgroup g
where  d.GROUP_NUMBER  = g.GROUP_NUMBER (+)
order by g.name, d.disk_numberSQL>   2    3    4    5    6    7    8    9   10
 11  /

DISK_GROUP                     DISK_NUMBER DISK_NAME
------------------------------ ----------- ------------------------------
PATH
--------------------------------------------------------------------------------
  TOTAL_MB HEADER_STATU
---------- ------------
DATA                                     0 DATA_0000
/dev/oracleasm/disks/NYCOEMDATA00
    306176 MEMBER

[oracle@oem01 etc]$ cd /dev/oracleasm

[oracle@oem01 oracleasm]$ cd disks

[oracle@oem01 disks]$ ls

OEMDATA00

[oracle@oem01 disks]$ ls -la

total 0

drwxr-xr-x. 1 root   root         0 May 29 15:04 .

drwxr-xr-x. 4 root   root         0 May 29 15:04 ..

brw-------. 1 oracle oinstall 8, 49 Sep 28 09:06 OEMDATA00

[oracle@oem01 disks]$ oracleasm listdisks

OEMDATA00

[oracle@oem01 disks]$ oracleasm querydisk -d OEMDATA00

Disk "OEMDATA00" is a valid ASM disk on device [8,49]

[oracle@oem01 disks]$ ls -l /dev/* | grep 8, | grep 49

brw-rw----. 1 root disk       8,  49 May 29 15:41 /dev/sdd1

From fdisk -l command :  

Disk /dev/sdd: 322.1 GB, 322122547200 bytes, 629145600 sectors

Using sed for word count

Not sure how much use this is but using sed to count number of strings in a file e.g. how many times does Python appear in test.txt

[oracle@usnyssmtaora03 ~]$ cat test.txt
1
2
Python
this is a test
34
9
Perl
Python
Python
Python
Python
Python
Python
Python

[oracle@usnyssmtaora03 ~]$ sed -n 's/Python/&/gp' test.txt |sed 's/Python/&\n/g'|sed '/^ *$/d'|sed -n '$='
8


Search for cubica in a file i.e. string /u01/cubica - replace the string with cubicb and keep a previous copy of the file.

#!/bin/sh

for f in `find . -name '*.txt' -exec grep -il 'cubica' {} \;`
do
sed 's?cubica?cubicb?g' $f > ${f}.new
cp -p $f ${f}.prev
mv ${f}.new $f
done

MySQL dump / restore (quick notes)

Some quick notes on dump / restore of a MySQL database.

REM DUMP A DATABASE TO FILE NOTE: the -- database option will include the CREATE DATABASE IF NOT EXISTS AND USE DATABASE COMMANDS

mysqldump --host localhost -P 3306 -u root -p --databases INFO_DB > /u99/backup/INFO_DB_new.dmp

REM DUMP A DATABASE TO FILE NOTE: the this version will NOT include the CREATE DATABASE IF NOT EXISTS AND USE DATABASE COMMANDS

mysqldump --host localhost -P 3306 -u root -p INFO_DB > /u99/backup/INFO_DB_new.dmp

REM DUMP A DATABASE TO FILE (zipped)

mysqldump --host localhost -P 3306 -u root -p --databases INFO_DB | gzip > /u99/backup/INFO_DB_new.dmp.gz

REM RESTORE A FILE

mysql --host localhost -P 3306 -u root -p < /u99/backup/INFO_DB_new.dmp

REM RESTORE A DATABASE INTO AN EXISTING DATABASE "my_dbase"

mysql --host localhost -P 3306 -u root -p my_dbase< /u99/backup/INFO_DB_new.dmp

REM RESTORE A COMPRESSED DATABASE INTO AN EXISTING DATABASE "my_dbase"

gunzip < myfile.sql.gz | mysql -u root -p my_dbase