<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cisong0721</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cisong0721]]></copyright><item><title><![CDATA[oracle temp 表空间]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288885</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288885</guid><author>cisong0721</author><pubDate>Tue, 21 May 2019 14:14:00 +0800</pubDate><description><![CDATA[1. 查询空间的使用率，有用视图dba_temp_file, v$temp_extent_pool。


select c.tablespace_name,   


   to_char(...]]></description><category></category></item><item><title><![CDATA[关于enq: TX - allocate ITL entry等待事件]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288886</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288886</guid><author>cisong0721</author><pubDate>Thu, 05 Jul 2018 10:58:43 +0800</pubDate><description><![CDATA[当表的ITL设置不能满足并发事务的需求时会产生此等待。数据块是oracle能够发出的最小i/o单位。在数据块中，数据块每当一个事务需要修改一个数据块时，需要在数据块头部获得一个可用的ITL槽，其中记录了当前事务的id，使用的...]]></description><category></category></item><item><title><![CDATA[Mysql host is blocked because of many connection errors;unblock解决方法]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288883</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288883</guid><author>cisong0721</author><pubDate>Tue, 29 May 2018 11:49:20 +0800</pubDate><description><![CDATA[原因： 同一个ip在短时间内产生太多（超过mysql数据库max_connect_errors的最大值）中断的数据库连接而导致的阻塞；


 解决方法：
 1、提高允许的max_connection_errors...]]></description><category></category></item><item><title><![CDATA[Oracle的temp表空间被占满]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288884</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288884</guid><author>cisong0721</author><pubDate>Mon, 05 Feb 2018 14:37:05 +0800</pubDate><description><![CDATA[前两天运维人员突然都给我发来小说报ORA-06512错，错误如下，提示temp无法扩展：
 

	
		ERR_1000001:未知的系统错误(ORA-01652:unabletoextendtempsegme...]]></description><category></category></item><item><title><![CDATA[数据库服务器故障]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288877</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288877</guid><author>cisong0721</author><pubDate>Wed, 31 Jan 2018 13:58:20 +0800</pubDate><description><![CDATA[一般来说，数据库服务器故障主要表现在一下几个方面：

	
		数据库无法登入；
	
	
		数据库运行缓慢；
	
	
		数据库出现坏块；
	
	
		访问数据库出现报错，无法正常执行某些功能；
	
...]]></description><category></category></item><item><title><![CDATA[同一台机器上DataGuard的密码问题]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288881</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288881</guid><author>cisong0721</author><pubDate>Fri, 20 Oct 2017 16:14:39 +0800</pubDate><description><![CDATA[DataGuard的数据传输方式有两种：LGWR和ARCH。其中前者传送的是联机日志的redo，后者传输的是归档。
FAL是9i推出的DataGuard的一大改进，它可以自动传送备库缺失的日志，一般情况下，它是不需要手工干预的...]]></description><category></category></item><item><title><![CDATA[Oracle在一台机器上搭建dataguard]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288875</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288875</guid><author>cisong0721</author><pubDate>Thu, 19 Oct 2017 16:03:25 +0800</pubDate><description><![CDATA[这两天找了台机器搭建dataguard。
1. 环境准备。
操作系统
[oracle ~]$ lsb_release -a
LSB Version:  :base-4.0-amd64:base-4.0-noarch...]]></description><category></category></item><item><title><![CDATA[Oracle 中$ORACLE_HOME/bin/oracle文件]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288880</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288880</guid><author>cisong0721</author><pubDate>Wed, 18 Oct 2017 10:34:52 +0800</pubDate><description><![CDATA[这两天在恢复完一次数据后，通过pl/sql登入到数据库报：
ORA-15025: 鏍娉驽肩ｇ "/dev/sddlmab"
ORA-27041: 鏍娉驽兼浠?
Linux-x86_64 Error: 13: Permiss...]]></description><category></category></item><item><title><![CDATA[Oracle asm磁盘中新加磁盘]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288876</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288876</guid><author>cisong0721</author><pubDate>Thu, 12 Oct 2017 16:11:54 +0800</pubDate><description><![CDATA[1. 新分LUN到主机上，使用fdisk -l进行检查，以下命令可以检查磁盘的scsi_id号。
scsi_id -u -g /dev/sd*

2. 重启udev进程/sbin/start_dev

3. 检查磁盘...]]></description><category></category></item><item><title><![CDATA[Oracle 在asm前使用udev绑定共享存储]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288879</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288879</guid><author>cisong0721</author><pubDate>Thu, 12 Oct 2017 15:38:56 +0800</pubDate><description><![CDATA[1. 在root用户下使用fdisk -l 查询主机上的盘，此次给主机分配了4块2T左右的盘，由于多路径的影响看到了8块盘，可以不用管，用其中4块就行。
# fdisk -l | grep Disk
WARNING: GPT...]]></description><category></category></item><item><title><![CDATA[Oracle重建控制文件]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288873</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288873</guid><author>cisong0721</author><pubDate>Tue, 10 Oct 2017 10:06:31 +0800</pubDate><description><![CDATA[这几天一直在做恢复测试，偶尔要重建数据库控制文件，记下下面语句：
alter database backup controlfile to trace as '/home/oracle/create_ctl.trc';

...]]></description><category></category></item><item><title><![CDATA[Oracle恢复误操作删除掉的表]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288872</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288872</guid><author>cisong0721</author><pubDate>Wed, 23 Aug 2017 15:28:16 +0800</pubDate><description><![CDATA[1. 删除表中数据两种方法
a. delete * from table;
b. truncate table table;

2. 删除整个表
drop table table;

如何恢复不小心drop掉的表呢...]]></description><category></category></item><item><title><![CDATA[ora-01000的处理思路]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288870</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288870</guid><author>cisong0721</author><pubDate>Mon, 31 Jul 2017 16:19:02 +0800</pubDate><description><![CDATA[今天有开发的同学发过来一个问题，在执行程序的时候报ora-01000错，所以研究了下。
从网上找了些帖子看了下，链接：
http://blog.youkuaiyun.com/msdnchina/article/details/49755...]]></description><category></category></item><item><title><![CDATA[Mysql general query log]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288869</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288869</guid><author>cisong0721</author><pubDate>Thu, 27 Jul 2017 14:52:17 +0800</pubDate><description><![CDATA[官方解释：
General query log：Established client connections and statements received from clients.
Mysql 打开general log...]]></description><category></category></item><item><title><![CDATA[Mysql在windows上安装后卸载重新安装需要root用户密码]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288866</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288866</guid><author>cisong0721</author><pubDate>Wed, 26 Jul 2017 17:25:18 +0800</pubDate><description><![CDATA[今天准备继续学习Mysql，把当前windows上的Mysql环境给卸载了重装，在安装的过程中一直报需要current root password，一直不知道咋回事，下面是解决办法。

1.清除MYSQL的安装目录,默认是C...]]></description><category></category></item><item><title><![CDATA[Oracle 11g Dataguard 暂停物理备库的日志传输]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288874</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288874</guid><author>cisong0721</author><pubDate>Tue, 18 Jul 2017 10:03:17 +0800</pubDate><description><![CDATA[这两天生产端的日志产生过多导致灾备端的归档日志目录满的现象，在清除灾备端的日志后发现log_archive_dest_2处于error状态，需要将其enable。在实际生产系统中，通常有这样的场景，例如在系统维护日，对主库...]]></description><category></category></item><item><title><![CDATA[静态监听]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288868</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288868</guid><author>cisong0721</author><pubDate>Tue, 13 Jun 2017 13:54:50 +0800</pubDate><description><![CDATA[[oracle@DCDRJFC3X-R610 admin]$ more listener.ora
# listener.ora Network Configuration File: /ulic/app/oracle/prod...]]></description><category></category></item><item><title><![CDATA[Truncate table时不管使用drop storage或reuse storage都会讲HWM重新设置]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288871</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288871</guid><author>cisong0721</author><pubDate>Tue, 09 May 2017 16:59:20 +0800</pubDate><description><![CDATA[A, B 为两个Table .
A, B 的数据分别放在 erp_data 表空间下
A, B 的索引分别放在 erp_indx 表空间下
那么
我们使用下面的两个语句删除两个表中的数据
Truncate ...]]></description><category></category></item><item><title><![CDATA[Oracle 临时表空间的概念]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288865</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288865</guid><author>cisong0721</author><pubDate>Thu, 13 Apr 2017 11:30:53 +0800</pubDate><description><![CDATA[临时表空间用来管理数据库排序操作以及用于存储临时表、中间排序结果等临时对象,当ORACLE里需要用到SORT的时候，并且当PGA中sort_area_size大小不够时，将会把数据放入临时表空间里进行排序。像数据库中一些操...]]></description><category></category></item><item><title><![CDATA[Oracle11g Data Guard 暂停物理备库的日志传输]]></title><link>https://blog.youkuaiyun.com/cisong0721/article/details/100288867</link><guid>https://blog.youkuaiyun.com/cisong0721/article/details/100288867</guid><author>cisong0721</author><pubDate>Thu, 30 Mar 2017 15:30:27 +0800</pubDate><description><![CDATA[Oracle11g Data Guard 暂停物理备库的日志传输（log_archive_dest_state_n的defer参数）
在实际生产系统中，通常有这样的场景，例如在系统维护日，对主库进行大量的业务更新，会有大...]]></description><category></category></item></channel></rss>