<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congnie1720的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congnie1720</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congnie1720]]></copyright><item><title><![CDATA[数据文件丢失]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366885</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366885</guid><author>congnie1720</author><pubDate>Thu, 24 May 2012 17:21:49 +0800</pubDate><description><![CDATA[环境：数据库无法关闭，发现数据文件对视。如果该数据文件不重要（可以删除），想要正常关闭数据库可以用参照以下：SQL&gt; shutdown immediate;ORA-01116: error in...]]></description><category></category></item><item><title><![CDATA[在线重定义（普通表转换分区表）]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366883</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366883</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:48:23 +0800</pubDate><description><![CDATA[测试过程：
SQL&gt; CREATE TABLE b  2  (   3      id NUMBER NOT NULL PRIMARY KEY, 
  4      name varchar(20)...]]></description><category></category></item><item><title><![CDATA[分区表]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366882</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366882</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:47:56 +0800</pubDate><description><![CDATA[1、时间分区： CREATE TABLE test_time (     id NUMBER NOT NULL PRIMARY 
KEY,     time DATE) PARTITION BY RANGE...]]></description><category></category></item><item><title><![CDATA[specification does not match any archive log in the recovery catalog;]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366881</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366881</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:47:27 +0800</pubDate><description><![CDATA[问       题：为什么会出现specification does not match any archive log in the recovery 
catalog；
备份脚本：
run{
.....]]></description><category></category></item><item><title><![CDATA[csscan使用]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366880</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366880</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:45:18 +0800</pubDate><description><![CDATA[数据迁移的时候可以使用csscan工具扫描数据库，把一些不兼容的字符查出来(例如：ZHS16GBK中一个汉字占两个字节，在AL32UTF8中占用3个字节，这就可能导致数据从ZHS16GBK到AL32UTF8时...]]></description><category></category></item><item><title><![CDATA[ORA-02374 ORA-12899 ORA-02372 (impdp)]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366877</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366877</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:44:53 +0800</pubDate><description><![CDATA[今天使用数据泵导入数据的时候报：
ORA-02374: conversion error loading table 
"HR2QAS01"."V_PS_STAFFPOS_REPTO_PUB_MT"ORA...]]></description><category></category></item><item><title><![CDATA[ORA-01756: quoted string not properly terminated]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366878</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366878</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:44:07 +0800</pubDate><description><![CDATA[今天遇ORA-01756错误：
 
SQL&gt; comment on table ETL_TMP_STOCKSH is 'xx表';ERROR:ORA-01756: 
quoted string n...]]></description><category></category></item><item><title><![CDATA["-isas-song ti-medium-r-normal--*-140-*-*-c-*-gb2312.1980-0"]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366879</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366879</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:42:48 +0800</pubDate><description><![CDATA[linux安装oracle时出现乱码，报错：
 
[oracle@ggx ~]$ dbcaWarning: Cannot convert string "-isas-song 
ti-medium-r-...]]></description><category></category></item><item><title><![CDATA[ORA-01861: literal does not match format string (Limuxrman/recover)]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366837</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366837</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:41:59 +0800</pubDate><description><![CDATA[RMAN&gt; recover database until time '2012-02-29:21:30:00';
Starting recover at 2012-02-29:22:47:33usin...]]></description><category></category></item><item><title><![CDATA[flashback闪回删除]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366841</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366841</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:41:07 +0800</pubDate><description><![CDATA[SQL&gt; show parameter bin
NAME                                 TYPE        
VALUE--------------------...]]></description><category></category></item><item><title><![CDATA[linux 使修改后的IP生效]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366928</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366928</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:40:41 +0800</pubDate><description><![CDATA[linux下修改IP后可以通过下面命令是IP生效：
service network restart
			
			
                                           ...]]></description><category></category></item><item><title><![CDATA[RMAN-03009 ORA-19569 —— rman 备份]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366834</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366834</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:40:13 +0800</pubDate><description><![CDATA[RMAN&gt; run{2&gt; allocate channel ch1 type disk;3&gt; allocate 
channel ch2 type disk;4&gt; allocate ...]]></description><category></category></item><item><title><![CDATA[生成AWR报错 ORA-06502 ORA-06512]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366833</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366833</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:39:39 +0800</pubDate><description><![CDATA[生成AWR报错：
环境：原.dmp文件为10.2.0.3.0
           目标数据库11.2.0.3.0
导入没有异常，生成AWR时报错
ERROR:ORA-06502: PL/SQL: n...]]></description><category></category></item><item><title><![CDATA[linux kernel.shmall shemax shemin参数详解]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366869</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366869</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:38:40 +0800</pubDate><description><![CDATA[linux kernel.shmall shemax shemin参数详解  （转）
Linux X86-64操作系统，Oracle 
10g数据库，由8G加到16G，把kernel.shmmax参数改到...]]></description><category></category></item><item><title><![CDATA[linux RAC开机自动启动数据库]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366918</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366918</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:38:04 +0800</pubDate><description><![CDATA[/etc/init.d/init.crs enable
/etc/init.d/init.crs disable
 
 
查看是否设置成功
在/etc/oracle/scls_scr/smsdbra...]]></description><category></category></item><item><title><![CDATA[shared_pool_reserved_size]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366897</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366897</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:37:39 +0800</pubDate><description><![CDATA[shared_pool中包含两个参数，分别是shared_pool_reserved_size和shared_pool_size 
shared_pool_size 
这个参数就是共享池的大小。share...]]></description><category></category></item><item><title><![CDATA[latch: cache buffers chains]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366830</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366830</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:37:06 +0800</pubDate><description><![CDATA[今天在看一个客户的AWR，在top 5中。发现 latch: cache buffers chains 
等待事件非常高，我就在网上查了一下，把结果记录下来。
 
cache buffers 
cha...]]></description><category></category></item><item><title><![CDATA[Library Cache Latch]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366840</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366840</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:36:21 +0800</pubDate><description><![CDATA[首先需要获得Library Cache Latch，根据SQL的HASH_VALUE值在Library 
Cache中寻找是否存在可共享的代码。如果找到则为软解析，Server进程获得该SQL执行计划，转向...]]></description><category></category></item><item><title><![CDATA[windows 自动rman 备份]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366827</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366827</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:35:54 +0800</pubDate><description><![CDATA[创建一个.bat文件
start_rman.bat
D:\app\Administrator\product\11.2.0\dbhome_1\BIN\rman target / cmdfile 
D:\...]]></description><category></category></item><item><title><![CDATA[回环网卡配置]]></title><link>https://blog.youkuaiyun.com/congnie1720/article/details/100366828</link><guid>https://blog.youkuaiyun.com/congnie1720/article/details/100366828</guid><author>congnie1720</author><pubDate>Sun, 20 May 2012 13:34:45 +0800</pubDate><description><![CDATA[可以在cmd  中输入   




OK了，然后在看一下IP （ipconfig)
重新配置一下。
			
			
                                     ...]]></description><category></category></item></channel></rss>