-
编辑 删除
更改字符集
1.更改数据库字符集为GBKSHUTDOWN IMMEDIATE; STARTUP MOUNT EXCLUSIVE; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE NATIONAL CHARACTER...
-
编辑 删除
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...
-
编辑 删除
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 ...
-
编辑 删除
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的用户名...
-
编辑 删除
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...
