<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congchen3611</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congchen3611]]></copyright><item><title><![CDATA[20150908日常工作总结]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417496</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417496</guid><author>congchen3611</author><pubDate>Tue, 08 Sep 2015 23:28:21 +0800</pubDate><description><![CDATA[1.安装oracle前，要好好想想内核参数的配置
2.创建DG时
1）之前 创建了密码文件，但是分别是自己执行的，创建语句，出了问题。所以最好是，主库建了 拷贝过去 改名
2）主备db_unique_name 不同的时候要...]]></description><category></category></item><item><title><![CDATA[日常工作总结20150901]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417495</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417495</guid><author>congchen3611</author><pubDate>Wed, 02 Sep 2015 17:26:46 +0800</pubDate><description><![CDATA[1.在生产中进行操作，切记利用一个文本记录操作步骤以及命令
2.aix中用nmon+m可以查看内存使用情况
3.linux中用free可以查看内存使用情况
4.重建不可用的索引时，改变指针，在新的地方建立索引后删掉失效的索...]]></description><category></category></item><item><title><![CDATA[日常工作总结20150831]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417494</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417494</guid><author>congchen3611</author><pubDate>Tue, 01 Sep 2015 20:09:07 +0800</pubDate><description><![CDATA[今天开始准备每天把工作中遇到的问题以及学到的东西进行简单的记录
1.对于给予的任务，太过于要求速度，在质量没保证的前提下，速度没有多大意义。导致经常犯一些低级的错误，这一点是今后改正的重点
2.对于迁移前期，需要确认源库与目...]]></description><category></category></item><item><title><![CDATA[10g dg 搭建]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417493</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417493</guid><author>congchen3611</author><pubDate>Sat, 07 Feb 2015 11:14:28 +0800</pubDate><description><![CDATA[1.主库创建参数文件，控制文件并发送到备库
create pfile='/tmp/pfile.ora' from spfile;
scp /tmp/pfile.ora 192.168.58.55:/tmp/

alter...]]></description><category></category></item><item><title><![CDATA[10G oracle 手动建库]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417492</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417492</guid><author>congchen3611</author><pubDate>Mon, 02 Feb 2015 23:39:00 +0800</pubDate><description><![CDATA[1.首先创建一个参数文件pfile.ora ：

可添加参数文件：
CLUSTER_DATABASE
COMPATIBLE
CONTROL_FILES
DB_BLOCK_SIZE
DB_CREATE_FILE_DE...]]></description><category></category></item><item><title><![CDATA[rman 命令知多少]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417490</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417490</guid><author>congchen3611</author><pubDate>Sat, 24 Jan 2015 15:19:23 +0800</pubDate><description><![CDATA[1.查看当前备份参数


	show all;


	show controlfile autobackup;


	


	2.列出数据库中所有的备份信息


	list backup；
...]]></description><category></category></item><item><title><![CDATA[rman备份，基础操作]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417491</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417491</guid><author>congchen3611</author><pubDate>Sat, 24 Jan 2015 14:38:27 +0800</pubDate><description><![CDATA[rman


	1.指定日志位置
rman target / log 路径


	2.执行SQL


	sql '';


	3.备份全库
backup database；


	4.批处...]]></description><category></category></item><item><title><![CDATA[创建外部表]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417489</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417489</guid><author>congchen3611</author><pubDate>Tue, 20 Jan 2015 20:52:29 +0800</pubDate><description><![CDATA[首先用dba权限创建direcory
create directory extdir as '路径';
再授权给要用的用户
grant read,write on directory extdir to scott;
...]]></description><category></category></item><item><title><![CDATA[11g grid安装]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417488</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417488</guid><author>congchen3611</author><pubDate>Tue, 20 Jan 2015 11:39:36 +0800</pubDate><description><![CDATA[安装完毕 linux


	/etc/hosts hostname
/etc/sysconfig/network
修改主机ID 以及修改主机名 一般不用默认的lockhost


	1.挂载yum
...]]></description><category></category></item><item><title><![CDATA[用 sqlldr加载Excel等其他文档内容到oracle]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417487</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417487</guid><author>congchen3611</author><pubDate>Tue, 20 Jan 2015 11:32:40 +0800</pubDate><description><![CDATA[1.首先将excel文档保存为csv格式 我命名为case2.dat//Windows下另存为 点保存类型即可找到CSV格式


	2.将此文件转存到oracle存在的操作系统某一路径（我的为redhat linu...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第12章笔记-相关动态视图]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417486</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417486</guid><author>congchen3611</author><pubDate>Tue, 04 Nov 2014 13:37:58 +0800</pubDate><description><![CDATA[1）和session相关的视图


	v$ession v$session_wait


	2）和session级统计信息相关的视图


	v$sesstat v$sysstat


	3）和等待事...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第5章笔记-表空间和数据文件]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417485</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417485</guid><author>congchen3611</author><pubDate>Tue, 04 Nov 2014 13:35:17 +0800</pubDate><description><![CDATA[1)
create tablespace eygle
datafile '/data2/ora10g/oradata/eygle/eyrle01.dbf'
size 100M autoexteng on next 1...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第7章笔记-临时表空间文件]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417482</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417482</guid><author>congchen3611</author><pubDate>Tue, 04 Nov 2014 13:34:14 +0800</pubDate><description><![CDATA[1）查看数据库的排序信息
select name,value from v$sysstat
2)sep 访问latch
select * from v$latchname 
where name like 'sor...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第8章笔记-备份与恢复]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417483</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417483</guid><author>congchen3611</author><pubDate>Tue, 04 Nov 2014 13:33:45 +0800</pubDate><description><![CDATA[1）
archive log list;
查看归档情况


	2）
log_archive_dest
log_archive_dest_n两种归档路径参数
修改路径


	alter system s...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第6章笔记-ASM]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417484</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417484</guid><author>congchen3611</author><pubDate>Tue, 04 Nov 2014 13:33:01 +0800</pubDate><description><![CDATA[1)instance_type区分实例类型

2）$ORACLE_HOME/dbs可以查看到参数文件，10g

3）
/u01/app/grid/product/11.2.0/grid/dbs可查看口令文件

4）...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第四章笔记-用户]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417524</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417524</guid><author>congchen3611</author><pubDate>Thu, 16 Oct 2014 20:41:47 +0800</pubDate><description><![CDATA[1）
create user eygle identified by eygle;
select username,default_tablespace,temporary_tabelspace from dba_us...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第二章笔记-EM,GRID]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417481</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417481</guid><author>congchen3611</author><pubDate>Thu, 16 Oct 2014 20:40:55 +0800</pubDate><description><![CDATA[1)
安装EM 
windows环境下：
 emca -h
emca -repos create


	2)启动EM
emctl start dbconsole


	3）当中文EM页面出现乱码，在...]]></description><category></category></item><item><title><![CDATA[循序渐进oracle，第一章笔记-数据库创建]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417536</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417536</guid><author>congchen3611</author><pubDate>Mon, 13 Oct 2014 20:20:14 +0800</pubDate><description><![CDATA[11G以前查看告警日志文件
show parameter background_dump_dest
11G以后
show parameter diag
select name,value from diag_in...]]></description><category></category></item><item><title><![CDATA[拜读深入浅出oracle杂谈]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417479</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417479</guid><author>congchen3611</author><pubDate>Mon, 06 Oct 2014 13:53:18 +0800</pubDate><description><![CDATA[正式接触oracle也有小半年了，从开始的毫无头绪到现在勉强了解的其体系结构。oracle的原厂培训让我入门，看了这本书让我感觉以前模糊的东西清晰了很多。不过，虽说这本书是入门级，但是感觉没有一点oracle的基础也是...]]></description><category></category></item><item><title><![CDATA[马士兵PLSQL笔记]]></title><link>https://blog.youkuaiyun.com/congchen3611/article/details/100417480</link><guid>https://blog.youkuaiyun.com/congchen3611/article/details/100417480</guid><author>congchen3611</author><pubDate>Mon, 06 Oct 2014 13:39:11 +0800</pubDate><description><![CDATA[set serveroutput on; 开启显示
begin 
end;
/ 开始结束；


	declare 申明变量，变量名 默认 V_ 开头


	v_num number := 0;...]]></description><category></category></item></channel></rss>