-
编辑 删除
dg搭建 单点-单点
SQL> select log_mode from v$database;LOG_MODE------------ARCHIVELOGSQL> select force_logging from v$database;FOR---NOSQL> alter database force logging;Database altered.SQL> select force_logging,log_mode from v$database;FOR LOG_MOD...
-
编辑 删除
multipath多路径配置
[root@localhost ~]# rpm -qa | grep device-mapperdevice-mapper-1.02.95-3.el6_7.3.x86_64device-mapper-multipath-0.4.9-87.el6.x86_64[root@localhost ~]# vi /etc/multipath.confdefaults {user_friendly_names yesudev_dir /devpath_grouping_policy...
-
编辑 删除
oracle 11G RAC 安装前准备和注意事项
VBoxManage createhd --filename /Volumes/mechine/VMware/virtualBox/11gsharestorage/asm1.vdi --size 2048 --format VDI --variant Fixed VBoxManage createhd --filename /Volumes/mechine/VMware/virtualBox/11gsharestorage/data1.vdi --size 40960 --format VDI --variant Fixed ...
-
编辑 删除
rman备份脚本 发送邮件通知
脚本大部分内容载录网上，本人仅添加邮件发送内容。邮件使用sendEmail包实现，需要自己单独安装。然后再次封装。#!/bin/bash#use Oracle Env.source ~/.bash_profile#Def backupdirdirname=`date "+%Y-%U"`lastweek=`date -d "-3 week" +%Y-%U`backup...
-
编辑 删除
数据库的常规检查脚本
SET MARKUP HTML ON SPOOL ON pre off entmap off;set feedback off;set termout off;set echo off;set verify off;set wrap on;set trimspool ...
-
编辑 删除
oracle获取ddl脚本
#!/bin/bash# author by ray# v6source ~/.bash_profileexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKoraname=****#定义获取ddl的函数getOracleTableDDL(){ userpass=$1 tname=$2 sqlplus...
-
编辑 删除
自动备份、截断分区表分区数据
#!/bin/bash# by ray# 2016-06-08. ~/.bash_profileexport NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"todayUtc=`date +%s000` #获取毫秒的utc时间tdate=`date +%F-%H%M%S` #获取当前时间days=185 #指定向前的天数，以获取保留的分区数truncdir=/tm...
-
编辑 删除
kill执行时间较长的会话
#!/bin/bash# by ray# 2016-06-16ksfile=/tmp/.kill_session.tmp #kill session 的文件路径killSqlFile=/tmp/.kill_session_temptablespace_highparallel.sql #kill脚本的路径 killSqlHisFile=/home/oracle/shell/killSqlHisInfo.txt #被kill的会话信息oraUser=****** #oracle的用户名...
-
编辑 删除
ogg状态检查，并重启
#!/bin/bash # by ray# 2016-06-06. ~/.bash_profilegglog=/tmp/.ggslog.logstatuslog=/home/oracle/shell/check_ogg_extractstatus.logcd /u01/oggwhile truedoecho "info all"|./ggsci > ${gglog}array=(`gre...
-
编辑 删除
ora-1652_solvent.sh
#!/bin/bash# by ray# 2016-05-19export ORACLE_BASE=/u01/oracleexport ORACLE_HOME=$ORACLE_BASE/11gexport ORACLE_SID=RACDB1export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:$ORACLE_HOME/li...
-
编辑 删除
ORA-00245 RMAN-08132解决
ChangesRAC Database release 11.2 CauseThe error description is:00245, 00000, "control file backup failed; target is likely on a local file system" // *Cause: Failed to create a control file backup because some process // si...
-
编辑 删除
Oracle11g ORA-609 TNS 12537 TNS 12560
###################alter_oraSID.log####################Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production Oracle Bequeat...
-
编辑 删除
事务压缩 对表的影响 compress for oltp
1 创建测试表并对添加数据 ………...省略2 修改表的属性为事务型压缩SQL> alter table TH_VEHICLE_ALARM_comp compress for oltp;Table altered.3 查询速度的对比非压缩表275 rows selected.Elapsed: 00:00:00.17...
