【脚本】备份数据库

1.shell脚本:startrman.sh #!/bin/bash # Created date: 2006-04-21 12:00 # Author : dbstyle # Name : startrman.sh # Description: # Backup database by rman # MODIFIED (MM/DD/YYYY) # dbstyle 04-21-2006 create script #------------------------------------------------------------------------------------------------------------ #Environment variable setting #------------------------------------------------------------------------------------------------------------ . /opt/oracle/.profile SH_HOME=/opt/oracle/dbmon/dbstyle/rmanbak export SH_HOME RM_COMMAND=/bin/rm MAIL_COMMAND=/bin/mail DBA="dbstyle@gmail.com" DATE=`date +"%Y%m%d"` week=`date +"%w"` #----------------------------------------------------------------------- #Confirm whether the oracle is runing #----------------------------------------------------------------------- sqlplus -s "/as sysdba"<<EOF whenever sqlerror exit 1 whenever oserror exit 1 select sysdate from dual; exit EOF if [ $? … [Read more...]

【脚本】查找占用率超过95%的表空间

Rem Created date: 2006-04-21 12:00 Rem Author : dbstyle Rem Name : datafile.sql Rem Description: Rem this script is used to get datafile information that used exceed 95%. Rem MODIFIED (MM/DD/YYYY) Rem dbstyle 04-21-2006 create script set pagesize 999 col file_name format a40 col tablespace_name format a10 select df.file_name,df.tablespace_name,df.bytes/1024/1024 size_M from dba_data_files df, (select a.tablespace_name tsname, round(a.bytes,2) Total_Mb, round(b.bytes,2) Free_Mb, round(a.MAXsize,2) MAXSIZE_Gb, (1 - (b.bytes/a.bytes))*100 Pct_used from ( select tablespace_name,sum(MAXBYTES/1024/1024/1024) MAXsize,sum(bytes)/1024/1024 bytes from dba_data_files group by tablespace_name ) a, ( select tablespace_name,sum(bytes)/1024/1024 bytes from dba_free_space group by tablespace_name ) b where a.tablespace_name = b.tablespace_name and (1 - (b.bytes/a.bytes))*100>95) tn where tn.tsname=df.tablespace_name order by df.file_name; … [Read more...]

【SEMINAR】ICBC Data Center Technical Seminar

结束了在工行数据中心的技术交流,大家对技术的严谨以及一丝不苟的态度深深感染了我,能够在这样的团队中工作是求之不得的。此次活动让人意犹未尽,期待和大家再次的相聚! … [Read more...]