<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congkutu8778的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congkutu8778</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congkutu8778]]></copyright><item><title><![CDATA[Notes about Parsing in Oracle]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420026</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420026</guid><author>congkutu8778</author><pubDate>Thu, 02 Sep 2010 13:51:05 +0800</pubDate><description><![CDATA[This is just some casual notes about parsing. For more information regarding parsing and how to find out/resolve p...]]></description><category></category></item><item><title><![CDATA[How I met the right function:)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420016</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420016</guid><author>congkutu8778</author><pubDate>Thu, 02 Sep 2010 13:44:23 +0800</pubDate><description><![CDATA[The other day I was asked about tips on Oracle developing. So Today I am going to tell you the story about how I m...]]></description><category></category></item><item><title><![CDATA[启动Physical Standby...]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420022</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420022</guid><author>congkutu8778</author><pubDate>Sun, 18 Jan 2009 18:27:51 +0800</pubDate><description><![CDATA[今天突然被要求启动一个instance的standby，接到request之后脑子里迅速搜索相关知识，结果只有一些零散的命令片断...当时记得再劳的知识许久不用也光光啊
还有偶有online document这一法宝~打开10...]]></description><category></category></item><item><title><![CDATA[关于Oracle Timezone的一点总结]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420024</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420024</guid><author>congkutu8778</author><pubDate>Fri, 16 Jan 2009 18:40:57 +0800</pubDate><description><![CDATA[背景描述：如果需要支持一个国际化的应用，那么数据库端的国际化特性的支持也就显得尤其重要。Oracle中有很多特性支持国际化，如字符集、时区等等。如果相关参数设置不当，或者由于对相关特性不够了解，以至于在设计阶段没有考虑完全，那么...]]></description><category></category></item><item><title><![CDATA[新年新气象，希望2009能有好的积累]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420021</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420021</guid><author>congkutu8778</author><pubDate>Sun, 04 Jan 2009 18:32:05 +0800</pubDate><description><![CDATA[看看空间左边的归档，真是惨不忍睹啊...08年下半年几乎就没怎么积累，虽然说专注了很多技术以外的事情，但是这里也不能不来啊...
09年要好好反思了，争取多多学习，多多实践，多多赚取实际经验，多多写博客~~~
希望等到自己有...]]></description><category></category></item><item><title><![CDATA[PUPBLD.SQL]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420020</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420020</guid><author>congkutu8778</author><pubDate>Mon, 21 Jul 2008 14:31:19 +0800</pubDate><description><![CDATA[好久没有更新博客了，最近一直很忙，忙于一些机械的事情，所以也懒得来更新了。
今天在使用一个很久没用的库时遇到了一下错误信息： 
Error accessing PRODUCT_USER_PROFILEWarning: Pr...]]></description><category></category></item><item><title><![CDATA[TNS-03505: Failed to resolve name --  不小心带来的错误！！！]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420014</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420014</guid><author>congkutu8778</author><pubDate>Wed, 07 May 2008 18:36:22 +0800</pubDate><description><![CDATA[本地建了好几个库，不想老是set oracle_sid=***切换，太麻烦。尝试在tnsname.ora文件中加了一个连接描述符，如下：
ORA10G =(DESCRIPTION = (ADDRESS_LIST =...]]></description><category></category></item><item><title><![CDATA[ORA-32773: operation not supported for smallfile tablespace USERS 解决]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420023</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420023</guid><author>congkutu8778</author><pubDate>Sun, 04 May 2008 15:45:18 +0800</pubDate><description><![CDATA[错误描述：
SQL&gt; alter tablespace users resize 300m;alter tablespace users resize 300m*ERROR at line 1:ORA-32773: op...]]></description><category></category></item><item><title><![CDATA[其他恢复技术总结 —— Logminer, DBPITR, TSPITR(3)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420019</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420019</guid><author>congkutu8778</author><pubDate>Sun, 04 May 2008 15:25:20 +0800</pubDate><description><![CDATA[//==============================================================//= Example 3: Using Continuous Mining to Include ...]]></description><category></category></item><item><title><![CDATA[其他恢复技术总结 —— Logminer, DBPITR, TSPITR(2)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420011</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420011</guid><author>congkutu8778</author><pubDate>Sun, 04 May 2008 14:57:53 +0800</pubDate><description><![CDATA[前言：Logminer有时候能完成Flashback由于undo retention等问题不能完成的任务，比如，查询比较长时间（超过undo rentention）以前某张表被谁改动过。本篇分三个主题，简单测试总结了一下Logm...]]></description><category></category></item><item><title><![CDATA[其他恢复技术总结 —— Logminer, DBPITR, TSPITR(1)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420018</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420018</guid><author>congkutu8778</author><pubDate>Sun, 04 May 2008 14:36:06 +0800</pubDate><description><![CDATA[前言：Flashback 技术之外，Oracle 还提供了其他很多有用的恢复工具和方法，本次针对Logminer, DBPITR, TSPITR做一个总结。
//================================...]]></description><category></category></item><item><title><![CDATA[Oracle 10g Flashback 技术小结 (3)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420008</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420008</guid><author>congkutu8778</author><pubDate>Sun, 04 May 2008 14:16:31 +0800</pubDate><description><![CDATA[//================================================================//Flashback database to undo an resetlogs operat...]]></description><category></category></item><item><title><![CDATA[Oracle 10g Flashback 技术小结 (2)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420017</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420017</guid><author>congkutu8778</author><pubDate>Wed, 30 Apr 2008 15:27:17 +0800</pubDate><description><![CDATA[//=============================================================// Failure of Trying to flashback from truncating t...]]></description><category></category></item><item><title><![CDATA[Oracle 10g Flashback 技术小结 (1)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420015</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420015</guid><author>congkutu8778</author><pubDate>Wed, 30 Apr 2008 13:17:57 +0800</pubDate><description><![CDATA[概述：Flashback 技术在Oracle 10g中提供了更强大的功能。它包括了table level的Flashback Query, Flashback Version Query, Flashback Transacti...]]></description><category></category></item><item><title><![CDATA[Notes of Backup and Recovery Basics (Oracle Online Documents)]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420013</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420013</guid><author>congkutu8778</author><pubDate>Wed, 30 Apr 2008 12:56:50 +0800</pubDate><description><![CDATA[Just some casual notes
[Begin]
At the physical level, Oracle Flashback Database provides a more efficient direct...]]></description><category></category></item><item><title><![CDATA[ORA-12638: Credential retrieval failed 问题解决]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420005</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420005</guid><author>congkutu8778</author><pubDate>Thu, 24 Apr 2008 13:26:22 +0800</pubDate><description><![CDATA[[问题描述] 用RMAN TARGET / 连接RMAN失败，想起sqlnet.ora中认证方式被我改成了none，便改回为NTS，即SQLNET.AUTHENTICATION_SERVICES = (NTS)。后sqlplus...]]></description><category></category></item><item><title><![CDATA[一个关于客户端和数据库版本不一致的问题]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420010</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420010</guid><author>congkutu8778</author><pubDate>Wed, 23 Apr 2008 13:23:32 +0800</pubDate><description><![CDATA[问题描述：昨天下午删除了一个测试表，今天突然要用到，想恢复。于是去recyclebin看了一下，发现还在，于是用flashback drop去恢复，但是出现以下错误：
SQL&gt; set linesize 200SQL&g...]]></description><category></category></item><item><title><![CDATA[RMAN恢复案例四 — 模拟硬盘损坏在其他机器上恢复]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420012</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420012</guid><author>congkutu8778</author><pubDate>Tue, 15 Apr 2008 19:37:48 +0800</pubDate><description><![CDATA[实验环境：Windows XP + Oracle 9.2.0.1
基本步骤如下：
1. 用RMAN做数据库全备，由于配置了controlfile autobackup，所以备份集中包含了datafile, control...]]></description><category></category></item><item><title><![CDATA[数据文件SCN的一致性问题]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420003</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420003</guid><author>congkutu8778</author><pubDate>Mon, 14 Apr 2008 20:29:19 +0800</pubDate><description><![CDATA[[说明]模仿eygle大师的一篇文章，原文章请参考：http://www.eygle.com/archives/2005/08/eiaescnaeooeaoi.html 
回答几个留言板上的问题:1、数据库正常运行中，所有数据...]]></description><category></category></item><item><title><![CDATA[关于checkpoint cnt和checkpoint scn]]></title><link>https://blog.youkuaiyun.com/congkutu8778/article/details/100420009</link><guid>https://blog.youkuaiyun.com/congkutu8778/article/details/100420009</guid><author>congkutu8778</author><pubDate>Mon, 14 Apr 2008 19:47:28 +0800</pubDate><description><![CDATA[[说明]模仿eygle大师的一篇文章，自己动手做了一下，感觉只有这样才能印象深刻。原文参考：http://www.eygle.com/archives/2004/06/checkpoint_scn_ckpcnt.html 
1...]]></description><category></category></item></channel></rss>