Oracle±¸·Ý½Å±¾
Ä¿±ê£ºÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£¬Ö»Òª»á¼òµ¥µÄlinuxÃüÁî¾ÍÄÜʵÏÖoracle expµÄ×Ô¶¯±¸·Ý
»·¾³£ºlinux as3+oracle9i
¾ßÌåµÄ²½Ö裺
1.ÓʼþÉèÖÃ
[root@sxapp1 mail]# cd /etc/mail
[root@sxapp1 mail]# mv submit.cf submit.cfbak
[root@sxapp1 spool]# chmod a+wrx mqueue/
[root@sxapp1 mail]# echo "sdsdssd"|mail -s "sda"westlife_xu@eyou.com
2.½¨Á¢±¸·ÝĿ¼
[root@sxapp1 mail]# su - oracle
[oracle@sxapp1 oracle]$ mkdir -p /home/oracle/phy_backup/data --±¸·ÝÎļþ´æ·ÅĿ¼
[oracle@sxapp1 oracle]$ mkdir -p /home/oracle/phy_backup/log --±¸·ÝµÄlog·¾¶
[oracle@sxapp1 oracle]$ cd /home/oracle/phy_backup
3.±¸·Ý½Å±¾±àд£¬²âÊÔ£¨½Å±¾Òª¸ù¾ÝÐèÇó΢µ÷£¬ÎÒÒѾ²âÊÔͨ¹ýÁË£©
[oracle@sxapp1 phy_backup]$ vi exp.sh
#!/bin/sh
. /home/oracle/.bash_profile
#define variable......
backup_date=`date +%Y%m%d`
bak_home=/home --df -kÀïÃæ±ØÐëÄÜ¿´¼û
backup_dest=/home/oracle/phy_backup/data --¸ù¾ÝÐèÒªÌîд
backup_log=/home/oracle/phy_backup/log --¸ù¾ÝÐèÒªÌîд
RECIPT='westlife_xu@eyou.com' --±¨¾¯ÓʼþÉèÖÃ
--¼ì²é´ÅÅÌ¿Õ¼ä
# Check local disk space..................................
USED=` df -k|grep $bak_home|awk '{print $5}'|awk -F% '{print $1}'`
if [ $USED -gt 85 ]; then
echo "Disk space is full\243\254please check it"|mail -s "exp full backup failed" $RECIPT
exit 1
fi
--¿ªÊ¼±¸·Ý
#starting exp backup.....
exp system/abc123 full=y buffer=65536 file=$backup_dest/data_$backup_date.dmp log=$backup_log/data_$backup_date.log
--ɾ³ý¹ýÆڵı¸·ÝÎļþ
# delete expired backup ...
list=` find $backup_dest -mtime +7`
echo $list
rm -f $list
if [ $? -ne 0 ]; then
cat $backup_log/data_$backup_date.log|mail -s
Ïà¹ØÎĵµ£º
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_name;
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES ......
1¡¢ÏÂÔØ°²×°Microsoft Visual Studio 2008£º
ÏÂÔصØÖ·£ºhttp://www.microsoft.com/downloads/details.aspx?FamilyId=83C3A1EC-ED72-4A79-8961-25635DB0192B&displaylang=zh-cn£¬Õâ¸öÊÇ“Visual Studio 2008 רҵ°æ£¨90 ÌìÊÔÓð棩”¡£
°²×°²½ÖèÂÔ¡£
2¡ ......
select t.lot_number
from inv.mtl_onhand_quantities_detail t
left join mtl_system_items_b mi
on t.inventory_item_id = mi.inventory_item_id
where mi.segment1 like '101%' and mi.organization_id = 102
group by t.lot_number having count(*)=1 union
select t.lot_number||'x'
......
֮ǰ¿´µ½Ò»ÆªÎÄÕÂ, ¾õµÃ²»´í! ¿´Á˺ó,·¢¾õ×Ô¼º»¹ÓкܶàµØ·½ÐèÒª²¹×ã, »¹ÐèҪŬÁ¦°¡£¡ÈÎÖضøµÀÔ¶£¡
DBAÐèÒªµÄ¼¼ÄÜ
dbaÕÆÎյļ¼Êõ
1. os : linux,solaris»òÆäËûunixÆðÂëÒªÒ»ÖÖ
2. bash (²»¾«Í¨Ò²ÒªÊì) LINUXÓë ......
ÔÎÄ´«ËÍÃÅ£ºhttp://blog.csdn.net/wh62592855/archive/2009/11/06/4776631.aspx
¼ÇµÃÒÔÇ°ÔÚÂÛ̳Àï¿´µ½inthirtiesÓõ½¹ýWITH ASÕâ¸ö×ÖÑÛ£¬µ±Ê±Ã»ÌرðÔÚÒâ¡£½ñÌìÔÚÒ»¸öÌû×ÓÀïÓÖ¿´µ½ÓÐÈËÓÃÕâ¸ö£¬ËùÒÔ¾ÍÈ¥ÍøÉÏËÑÁËËÑÏà¹ØÄÚÈÝ£¬×Ô¼ºÐ¡ÊÔÁËÒ»°Ñ£¬Ð´ÏÂÀ´£¬·½±ãÒÔºóÍüÁ˵Ļ°Ñ§Ï°¡£
============================================ ......