Database Administrator, Blogger, Contributor
Posted by Mohamed Azar on January 22, 2012
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 81,000 times in 2011. If it were an exhibit at the Louvre Museum, it would take about 3 days for that many people to see it.
Posted in Uncategorized | Leave a Comment »
Posted by Mohamed Azar on December 21, 2011
I feel, this time the Oracle Magazine Jan/Feb 2012 has a special edition for who has received oracle excellence award. I am not added this list (excellence award) but My beloved teacher and my best adviser, Mr.Syed Jaffer Hussian included this list . Yes He got a Technologist of the year ,DBA 2011. Oracle always choose a right person to give this award. Again oracle proved, He has the right person for this award,2011.
My personally, He has a great knowledge in Oracle and related OS. He is easily addict with who has newly meet him.He is very nice person and also he has continuously helping peoples, not only Oracle and at all.
His interview is published at Oracle Magazine Jan/Feb 2012.
I am very happy for this honorable person, Mr.Syed Jaffer Hussain got this award. Happy, Healthy & Successful life for him forever.
Posted in Magazine | Tagged: oracle magazine | Leave a Comment »
Posted by Mohamed Azar on December 10, 2011
Today morning I just written a small script for taking full database using datapump and after I scheduled on every one week with cron.
#!/bin/bash
#Script to perform a full database export backup using by datapump on every wednesday
# Script Written by
# Mohamed Azar http://mohamedazar.com
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
ORACLE_SID=devcrm; export ORACLE_SID
expdp system/Admin123 directory=exportdb dumpfile=exportdb-$(date +%Y-%m-%d).dmp logfile=exportdb-$(date +%Y-%m-%d).log full=y exclude=statistics
# Send log to mail
tail -4 /u01/datapump/dumps/exportdb-$(date +%Y-%m-%d).log | mailx -s “Cronjob Oracle Export Output:SIEBELDEV” mazar@ace-ins.com#Remove old previous dumpfile
rm -rf /u01/datapump/dumps/previous/*.*#Find out last week dumpfiles and move to previous directory
cd /u01/datapump/dumps
chown -Rf oracle:oinstall *.dmp *.log
chmod -Rf 775 *.dmp *.log
find -mtime +6 -exec mv {} /u01/datapump/dumps/previous \;
gzip /u01/datapump/previous/*.*
gzip *.dmp *.log
Cronjob schedule :
I scheduled here , every week on wednesday at 04:00pm
[oracle@siebelpoc cronjob]$ vi cron.exportdb
0 16 * * 3 /u01/datapump/dumps/scripts/exportdb.sh[oracle@siebelpoc cronjob]$crontab cron.exportdb
Posted in Datapump, Scripts | Leave a Comment »
Posted by Mohamed Azar on November 26, 2011
Have a lot of method…Here one method below
[oracle@netbackuptest bin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 26 07:57:52 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select length(addr)*4 || '-bits' word_length from v$process where rownum=1; WORD_LENGTH --------------------------------------------- 64-bits SQL>
Posted in Scripts | 4 Comments »
Posted by Mohamed Azar on November 20, 2011
This download page offers a variety of links for virtual machine images for Oracle Solaris 11, including Oracle VM Templates for Oracle Solaris 11. These Oracle VM Templates speed the creation of Proof of Concept environments and other evaluation/development tasks by dramatically simplifying the installation process. Oracle Solaris VM Templates are available for both SPARC and x86-based systems.
Posted in Products Released | 1 Comment »
Posted by Mohamed Azar on November 20, 2011
How do we identify tablespace free space in database ?
SQL> SELECT /* + RULE */ df.tablespace_name "Tablespace", 2 df.bytes / (1024 * 1024) "Size (MB)", 3 SUM(fs.bytes) / (1024 * 1024) "Free (MB)", 4 Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free", 5 Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used" 6 FROM dba_free_space fs, 7 (SELECT tablespace_name,SUM(bytes) bytes 8 FROM dba_data_files 9 GROUP BY tablespace_name) df 10 WHERE fs.tablespace_name (+) = df.tablespace_name 11 GROUP BY df.tablespace_name,df.bytes 12 UNION ALL 13 SELECT /* + RULE */ df.tablespace_name tspace, 14 fs.bytes / (1024 * 1024), 15 SUM(df.bytes_free) / (1024 * 1024), 16 Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1), 17 Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes) 18 FROM dba_temp_files fs, 19 (SELECT tablespace_name,bytes_free,bytes_used 20 FROM v$temp_space_header 21 GROUP BY tablespace_name,bytes_free,bytes_used) df 22 WHERE fs.tablespace_name (+) = df.tablespace_name 23 GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used 24 ORDER BY 4 DESC; Tablespace Size (MB) Free (MB) % Free % Used ------------------------------ ---------- ---------- ---------- ---------- UNDOTBS1 130 102.5 79 21 USERS 5 3.625 73 28 VPX 1024 650.625 64 36 VUM 1000 601.75 60 40 SYSAUX 880 80.5625 9 91 SYSTEM 750 42.25 6 94 TEMP 119 0 0 100 7 rows selected. SQL>
Posted in Scripts | 7 Comments »
Posted by Mohamed Azar on October 31, 2011
During take backup through Veritas netbackup, it shows below errors
channel ch00: starting piece 1 at 2011-10-31:10:13:48 RMAN-03009: failure of backup command on ch01 channel at 10/31/2011 10:14:23 ORA-19513: failed to identify sequential file ORA-27206: requested file not found in media management catalog
The problem has occurred If you are added your client ip address in master netbackup server while configure backup policy.
So change client hostname with domain name instead of ip address of client.
Posted in Backup & Recovery | Leave a Comment »
Posted by Mohamed Azar on October 31, 2011
When i’m trying configure oracle backup on veritas netbackup, it showing the below errors
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> allocated channel: ch00 channel ch00: sid=125 devtype=SBT_TAPE channel ch00: Symantec/BackupExec/1.1.0 allocated channel: ch01 channel ch01: sid=90 devtype=SBT_TAPE channel ch01: Symantec/BackupExec/1.1.0 Starting backup at 2011-10-30:14:34:49 channel ch00: starting incremental level 0 datafile backupset channel ch00: specifying datafile(s) in backupset input datafile fno=00005 name=H:\BROKER\PACE01.DBF input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\UNDOTBS01.DBF input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\SYSAUX01.DBF input datafile fno=00014 name=H:\BROKER\PACE04.DBF input datafile fno=00012 name=D:\CIGNATBS\CCIDATA01.DBF input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\USERS01.DBF input datafile fno=00007 name=D:\ORACLE\CATALOG\BROKER\RMAN01.DBF channel ch00: starting piece 1 at 2011-10-30:14:34:50 channel ch01: starting incremental level 0 datafile backupset channel ch01: specifying datafile(s) in backupset input datafile fno=00006 name=H:\BROKER\FACE01.DBF input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\SYSTEM01.DBF channel ch01: starting piece 1 at 2011-10-30:14:34:51 RMAN-03009: failure of backup command on ch00 channel at 10/30/2011 14:34:52 ORA-19506: failed to create sequential file, name="bk_uhsmqdf8a_s1596_p1_t765902090", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: BEError(0x80004005) Unspecified error
Cause :
The problem has occured because I have already configured symantec backup exec agent software on particular database server, So it has created own orasbt.dll file in c:\windows\system32 directory and that particular database sbt device is configured with symantec backup exec . While the existing system running, I installed veritas netbackup client agent also on the same server without removing symantec backup exec and removed orasbt.dll file.
If symantec backup exec is already install on the same server, and if we are trying to install netbackup then it does not overwrite on orasbt.dll file.
This is the reason when i take backup, the allocated channel showing symantec backup exec not veritas oracle netbackup.
Solution :
Uninstall Both client software (Symantec Backup exec and Vertias ntbackup)
delete orasbt.dll file from ”C:\windows\system32\”
Install again Veritas Oracle netbackup. Now Its works fine.
RMAN> run {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> SEND 'NB_ORA_SERV=xxxxxx.ace-ins.com,NB_ORA_CLIENT=yyyyyy.ace-ins.com,N
B_ORA_POLICY=dbtest';
4> BACKUP INCREMENTAL LEVEL=0 FORMAT 'bk_u%u_s%s_p%p_t%t' DATABASE;
5> }
allocated channel: ch00
channel ch00: sid=147 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (20100104)
sent command to channel: ch00
Starting backup at 31-OCT-11
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTDB\SYSTEM01.D
BF
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTDB\SYSAUX01.D
BF
Posted in Backup & Recovery | 2 Comments »
Posted by Mohamed Azar on October 29, 2011
Hi, I’m here announce that I changed my wordpress blog domain with following address.
However If you clicked on my wordpress blog, it will automatically redirected to this address.
Enjoy your reading….:-)
Posted in Uncategorized | Leave a Comment »
Posted by Mohamed Azar on October 24, 2011
Here I just demonstrated how do we install two node rac on oracle Virtual Box.
Please refer before you try to install rac on virtual box.
Vmware Server rac installation guide , click below url.
Oracle 11gr2 two node rac installation guide on linux using vmware
Oracle Virtual Box 4.1.4
Download the below pdf document, I hope this document will helpful for you.
Oracle 11gr2 rac two node installation guide on linux using virtual box 4.1.4
Download right click on this URL , choose save target as and save it.
Posted in RAC & ASM | Leave a Comment »
